[Solved] merge same rows and show different fields in new column in sql
[ad_1] If there are maximum of two rows, this will work select Srn, SrnPrs,sDayDate,max(sTime) as sTime1, min(sTime) as sTime2 from table group by Srn, SrnPrs,sDayDate [ad_2] solved merge same rows and show different fields in new column in sql