-
Hi Gurus,
What function would I use to retrieve the latest date in a SQL?
Thanks!
Hemant
-
select min(sysdate) from what_ever;
-
11:13:38 SQL> select record_to_date from my_table;
RECORD_TO
---------
29-JUL-02
30-JUL-02
31-JUL-02
01-AUG-02
select min(record_to_date) from my_table
11:15:39 SQL> /
MIN(DISTI
---------
29-JUL-02
select max(record_to_date) from my_table
11:15:49 SQL> /
MAX(DISTI
---------
Cheers!
01-AUG-02
Cheers!
OraKid.
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
|