Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Selecting the minimum value across a row


Message #1 by Amitabh Premraj <amitabh@k...> on Thu, 15 Mar 2001 9:14:13 -0700
Maybe I'm missing the point but how about:

select min(date1), min(date2), min(date3) from table_with_dates

Don

> 
> I have 3 fields named date1, date2, date3 and i need to obtain the 
minimum 
> of these three values in a row.
> Is it possible using a select statement
> 
> 
> amitabh

  Return to Index