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

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