Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: lionkingden
- Order by date
-
Complicated Select from Data Dump
Thanks a lot Denny... u pointed me in the right direction... select unitno,latitude,longitude, Max(date||digits(time)) as dt from myGPSTable group by unitno u know the above code wont work in DB2 because with group by clause i cant put the fields latitude and longitude as they are neither in...- lionkingden
- Post #3
- Forum: ANSI_SQL
-
Complicated Select from Data Dump
I have a data dump table (myGPStable) of GPS data records, with fields (unitNo, latitude, longitude, date, time) every one hour the data gets dumped into the table from all the units... I want to get the latest latitude and longitude of all the units in a select statement (Note: the unitno...- lionkingden
- Thread
- Replies: 3
- Forum: ANSI_SQL
