Thanks a lot! I was looking for a way to do it with one simple SELECT statement, and I wasn't sure if it was possible. Thanks for your solution.
- Jake
Hi all,
I have a simple table that stores survey response records. 3 questions, 1 comment field, and a record id. The answers in each question column can be from 1 to 5.
recordid | q1 | q2 | q3
1 4 2 1
2 5 4 5
3 3 2 3
I would like to write a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.