|
View previous topic :: View next topic
|
| Author |
Message |
zacharti
New User
Joined: 15 Jun 2006
Posts: 13
|
|
|
|
Hi,
I have a doubt in writing a query, the purpose of the query is it retrieve a date from a table.
In the table if there are rows with null. then i should get null
but if there is no null then i should get max of the date.
eg:
if table 01 has 4 rows and the values are as below then i should get NULL
date
2007-10-19
2007-09-08
null
2007-02-01
answer = null
if table 01 has 4 rows and the values are as below then i should get 2007-10-19
date
2007-10-19
2007-09-08
2007-02-03
2007-02-01
answer = 2007-10-19
can anyone help me in writing a shingle query for the same. we can do the same with a cursor, but I want to know if we can do it through a single query or not. |
|
| Back to top |
|
 |
rag swain
New User
Joined: 17 Dec 2007
Posts: 33
Location: pune,INDIA
|
|
|
|
you can write query like
| Code: |
select max(char(date_col))
from table_name;
|
and use function NULLIF(CHAR(DATE_COL) with the query to find the result, though not yet tested. might some other day, quite late. |
|
| Back to top |
|
|
|
|
