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.
if table 01 has 4 rows and the values are as below then i should get NULL
answer = null
if table 01 has 4 rows and the values are as below then i should get 2007-10-19
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.