Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajasri
Starting Member
1 Post |
 Posted - 2011-09-05 : 07:52:41
|
| Hi All,My table contains UserName, Date, Count.UserName Date CountTest 01-08-2011 1Test 01-08-2011 2Test 02-08-2011 1Test 03-08-2011 5I need to select the values based on the date with group by UserName and date.Eg:UserName 1 2 3 .....31Test 3 1 5 ......Here 1,2,3 .... indicates date.2 1 1 ...... indicates countCan anyone tell me the query for this.Thanks in advance.Rajasri. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Selecting values from table based on the date