Re: max row from table
Posted by:
Rick James
Date: January 12, 2011 08:28PM
We're slipping. 28 hours, and no one has answered this trivial question.
SELECT id,
punch_in as max_punch_in -- no MAX()
FROM employees_punches_dev
WHERE employees_id = '438'
AND deleted = 0
ORDER BY punch_in DESC -- Sort the rows, largest punch_in first
LIMIT 1; -- Grab the first
Subject
Written By
Posted
Re: max row from table
January 12, 2011 08:28PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.