Home » SQL & PL/SQL » SQL & PL/SQL » sql statement help
sql statement help [message #18565] Tue, 05 February 2002 08:38 Go to next message
Salina
Messages: 1
Registered: February 2002
Junior Member
I would like to know of a sql statement which would query the entire database to return me the oldest date in the database for a specific criteria. Is there anyone who can help me to write this sql statemnt please. I need help on this urgently!

Thanks in advance

Salina
Re: sql statement help [message #18569 is a reply to message #18565] Tue, 05 February 2002 08:59 Go to previous messageGo to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
If you want that somebody can help you you need to be a little bit more precise.
For example:
what do you realy mean by the whole database (realy the whole database, only a schema or only one table)?
what do you mean by "the oldest date" ?
what kind of criteria?
Re: sql statement help [message #18571 is a reply to message #18565] Tue, 05 February 2002 09:24 Go to previous message
vk
Messages: 13
Registered: December 2001
Junior Member
use least(date column ) function on the date column
Previous Topic: Time field creation
Next Topic: Tune This Simple SQL
Goto Forum:
  


Current Time: Thu Apr 18 20:09:30 CDT 2024