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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-27 : 09:14:02
|
| Vikas Arora writes "I have one question, which has 4 answers.If a user chooses 1st answer he gets 1 point.If a user chooses 2nd answer he gets 0.75 point.If a user chooses 3rd answer he gets 0.50 point.and so on..........Now if 25 users are answering the same question then i need the count of those peoples who has choosed a particular answer maximum no. of times. Is there any type of function in sql server 7.0 which can do this thing. I am using ASP as front end, Windows 2000 Professional as OS." |
|
|
|
|
|
Query