| Oracle Max Function [message #230] |
Wed, 30 January 2002 07:01  |
Twan
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
Hi,
I have been trying to get the max() function to work in a query of mine. I am trying to find the max date. The max date in the table is 01-14-2002, but the query is returning 12-14-2001. The query is as follows:
SELECT MAX(DATE_COLUMN)
FROM TABLE
Is there another function that I should be using.
Thanks!
|
|
|
|
| Re: Oracle Max Function [message #231 is a reply to message #230] |
Wed, 30 January 2002 09:24  |
sokeh
Messages: 77
Registered: August 2000
|
Member |
|
|
that should have worked!
I don't know but try this and let me know if it works for you. It works for me just as your original query worked for me:
select max(date_column) from table
where date_column =(select max(date_column) from table)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
