Advertisement
- Home
- Microsoft
- Development
- MS SQL Server
- Sql Query for Questionaire Data
Advertisement
- 1. chapmandew 2,492,866
- 2. angelIII 2,311,810
- 3. mark_wills 745,570
- 4. aneeshatti... 623,069
- 5. BrandonG... 548,950
- 6. ScottPletc... 523,767
- 7. EugeneZ 393,777
- 8. acperkins 380,843
- 9. ee_rlee 353,240
- 10. dtodd 349,319
- 11. momi_sa... 296,832
- 12. mwvisa1 276,442
- 13. matthews... 259,351
- 14. cs97jjm3 245,703
- 15. appari 191,167
- 16. nmcdermaid 185,708
- 17. dqmq 175,308
- 18. rickchild 174,460
- 19. Zberteoc 170,438
- 20. MohammedU 169,998
- 21. brejk 169,574
- 22. dportas 162,055
- 23. Thomasian 153,702
- 24. jimpen 149,280
- 25. DanielWilson 142,230
- 1. angelIII 11,268,223
- 2. aneeshatti... 4,680,948
- 3. acperkins 4,369,303
- 4. ScottPletc... 4,337,819
- 5. chapmandew 2,492,866
- 6. arbert 2,245,195
- 7. Lowfatsp... 2,174,384
- 8. EugeneZ 1,669,939
- 9. imran_fast 1,484,261
- 10. rafrancisco 1,460,132
- 11. Hilaire 1,221,775
- 12. nmcdermaid 1,170,292
- 13. Nightman 1,148,504
- 14. Mr_Peer... 1,087,815
- 15. ptjcb 1,074,620
- 16. bhess1 1,073,837
- 17. dtodd 935,662
- 18. adathelad 793,208
- 19. matthews... 781,683
- 20. appari 778,404
- 21. Sirees 776,352
- 22. mark_wills 745,570
- 23. BriCrowe 722,959
- 24. amit_g 683,229
- 25. BrandonG... 646,746
| 10.09.2008 at 07:36AM PDT, ID: 23800992 | Points: 500 |
|
[x]
Attachment Details
|
||
Sql Query for Questionaire Data
Asked by MayoorPatel in MS SQL Server, SQL Server 2005
Tags: SQL
I have a questionaire which has 30 questions, each question has a multiple choice answer and the database records this as 1,2,3, or 4
I would like an SQL Query which tells me which answer was most popular for each question so the result set should give 2 columns "Question Number" and "Most Popular Answer"
I have attatched a screenshot to show how the data is recorded in the database. If you can help me with this query that would be great!Start Free Trial
I would like an SQL Query which tells me which answer was most popular for each question so the result set should give 2 columns "Question Number" and "Most Popular Answer"
I have attatched a screenshot to show how the data is recorded in the database. If you can help me with this query that would be great!Start Free Trial
Attachments:
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628
