[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
[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