kiraaaak Posted June 19, 2013 Report Posted June 19, 2013 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
kiraaaak Posted June 19, 2013 Author Report Posted June 19, 2013 [img]http://www.desigifs.com/sites/default/files/Brahmi%20pleaseee.gif?1290059733[/img]
kiraaaak Posted June 19, 2013 Author Report Posted June 19, 2013 space lu ekkada poinay naa royya .... manchiga edit chesi pedthe spaces ani levu post lo
kiraaaak Posted June 19, 2013 Author Report Posted June 19, 2013 18 views .. no reply[img]http://lh6.ggpht.com/-rH5dVGAmnAs/UU0h1s--YII/AAAAAAAAK3k/jE0cA9TUh24/s150/Brahmi.gif[/img]
kiraaaak Posted June 19, 2013 Author Report Posted June 19, 2013 [quote name='tyke' timestamp='1371680510' post='1303871871'] [/quote][img]http://lh6.ggpht.com/-wpVRCtWO9EU/UU0hvE08WcI/AAAAAAAAK3k/niOlWDWDGwo/s150/Brahmi-2.gif[/img]
kiraaaak Posted June 19, 2013 Author Report Posted June 19, 2013 chusi potaru kani okkadu matladadu endhi vayy [img]https://lh4.googleusercontent.com/-plA7-D8VEiA/UJb2RaJsXII/AAAAAAAAHuY/zavNvr0S1OA/s150/T.gif[/img]
Mustodi_2ndsetup Posted June 19, 2013 Report Posted June 19, 2013 [b][font=courier new,courier,monospace]select min(startdate),(case when min(enddate) is null then null else max(enddate)) enddate,name,id[/font][/b] [b][font=courier new,courier,monospace]from table[/font][/b] [b][font=courier new,courier,monospace]group by name,id[/font][/b] try chey
Mustodi_2ndsetup Posted June 19, 2013 Report Posted June 19, 2013 @kirak if min function doesnt take null then hard code nulls with least value and change ur logic i think u should be fine
kiraaaak Posted June 19, 2013 Author Report Posted June 19, 2013 [quote name='Giants' timestamp='1371681324' post='1303871906'] [b][font=courier new,courier,monospace]select min(startdate),(case when min(enddate) is null then null else max(enddate)) enddate,name,id[/font][/b] [b][font=courier new,courier,monospace]from table[/font][/b] [b][font=courier new,courier,monospace]group by name,id[/font][/b] try chey [/quote] ila raadu ba ... min(date) lo null teeskovatledu
kiraaaak Posted June 19, 2013 Author Report Posted June 19, 2013 [quote name='Giants' timestamp='1371681495' post='1303871917'] @kirak if min function doesnt take null then hard code nulls with least value and change ur logic i think u should be fine [/quote] correct ga septhivi ba ... ya adi undi kani adi kakunda edaina undaa ani ..
Mustodi_2ndsetup Posted June 19, 2013 Report Posted June 19, 2013 [quote name='kiraaaak' timestamp='1371681785' post='1303871928'] correct ga septhivi ba ... ya adi undi kani adi kakunda edaina undaa ani .. [/quote] adhi easy ne kadha null place lo 99 fetti case rasey
Recommended Posts