SELECT Num, empNum, lastName, travelerName, runTime, fltNum, depCity, timeZone
FROM Check_in
WHERE runTime =
(SELECT MIN( runTime )
FROM Check_in
WHERE runTime BETWEEN '2011-05-16 09:19:00'
AND '2011-05-16 09:21:00')
ASKER
ASKER
ASKER
ASKER
MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.
TRUSTED BY
Are you trying to pick two rows? One for min and one for max?
Not sure how you're using all of the fields, but something like this should work:
Good Luck,
Kent
Open in new window