-
rows with largest date
I have a table where one column is a date. How can I get all rows that contain the largest date in the table? I don't know how many rows to expect or what the largest date is.
If my data is
name | date
--------------------------------------------------
dog | 2010-03-20 20:10:10
cat | 2010-04-26 10:10:10
bird | 2010-04-25 23:59:59
rat | 2010-04-26 10:10:10
gnat | 2010-04-02 06:07:08
I would want my query to return:
cat | 2010-04-26 10:10:10
rat | 2010-04-26 10:10:10
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|