Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. WITH Wronguns AS (SELECT ID, ARRAY_AGG(WrongAnswer) WrongAnswers
  2.                     FROM Questions Q
  3.                      LEFT JOIN (SELECT * FROM WrongAnswers ORDER BY RANDOM()) WA ON Q.ID = WA.QuestionID
  4.                      GROUP BY Q.ID)
  5.   SELECT ID, Question, CorrectAnswer, (WrongAnswers)[1], (WrongAnswers)[2], (WrongAnswers)[3]
  6.     FROM Wronguns W
  7.     NATURAL JOIN Questions Q;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement