Time display query in sql
- by shanks
I have following data
UserID UserName LogTime LogDate
1 S 9:00 21/5/2010
1 S 10:00 21/5/2010
1 S 11:00 21/5/2010
1 S 12:00 21/5/2010
Need Output as:-
1 s 9:00 10:00 21/5/2010
1 s 11:00 12:00 21/5/2010