imp question [message #39034] |
Sat, 08 June 2002 00:58 |
kiran
Messages: 503 Registered: July 2000
|
Senior Member |
|
|
how to compare the different dates in the same column of a table and find the latest date?
|
|
|
Re: imp question [message #39035 is a reply to message #39034] |
Sat, 08 June 2002 01:50 |
Sujit Mahapatra
Messages: 19 Registered: March 2002
|
Junior Member |
|
|
It is important to know what u mean by latest date.
If it means the greatest of them all, then it is
simple:
SELECT MAX (date_field) FROM TABLE_NAME;
If u r talking about the date field that was entered
last (and that value may not be the greatest date
value), then boy, you are asking something you should
find a solution yourself / reform the query.
;-)
Sujit
|
|
|