@racle Sql Query Helping Kavali

[kiraaaak]

[quote name='Giants' timestamp='1371682120' post='1303871947']
adhi easy ne kadha null place lo 99 fetti case rasey
[/quote]
thanks ba .. that worked

[whatever]

[quote name='kiraaaak' timestamp='1371680136' post='1303871854']
start_date end_date name id
--------------------------------------------------------------------------
18-JUN-2013 (null) kiraaaak 10
19-JUN-2013 (null) kiraaaak 10
19-JUN-2013 29-JUN-2013 kiraaaak 10
09-JUN-2013 29-JUN-2013 kiraaaak 10
18-JUN-2013 01-DEC-9999 kiraaaak 10
01-OCT-2012 31-DEC-9999 kiraaaak 10



naaku final ga


start_date end_date name id
--------------------------------------------------------------------------
01-OCT-2012 (null) kiraaaak 10


kavali ... ante Start_date lo minimum and end_date lo if edaina oka value null unte final ga NULL else Max value ...

entha try chesna samaj aithaledu
[/quote]



select
min(start_date) as start_date,
CASE WHEN MAX(COALESCE(end_date, '12/31/9999')) = '12/31/9999' THEN NULL ELSE MAX(end_date) END AS end_date,
name,
id
from table_name
group by
name,
id


[font=inherit][size=2]
source : http://www.bidn.com/blogs/BradSchacht/ssis/993/select-null-as-max-or-min-in-sql-query[/size][/font]