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 |
|
keyursoni85
Posting Yak Master
233 Posts |
 Posted - 2012-02-15 : 12:29:08
|
| Hi,I have table for employee's rating employer wise.rating tables holds rating out of 10 and employee and employer id.I want to have highest rating (total sum) for employee among that employee's multiple ratings done by employers.please help. |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
keyursoni85
Posting Yak Master
233 Posts |
Posted - 2012-02-15 : 12:52:23
|
| [code]crid employeeid employerid categoryid rating ratingfrom1 1 2 1 5 101 1 2 2 4 101 1 3 1 10 101 1 3 2 8 10[/code]I want highest rating for employee among its employers rated..above ex. have 18 rating for employee for employer 3. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Ranking with highest count