>> How do I single out the record with the latest start time (time field

>> in MySQL)?

select *
from table a
where a.time = (select max(b.time) from table b)

note that this query may return more than one row if the timestamps are
the same...

http://www.w3schools.com/sql/sql_functions.asp

--
dc
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to