[Solved] merge same rows and show different fields in new column in sql

by


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

solved merge same rows and show different fields in new column in sql