SQL query problem of a Quiz program

From: Arup Rakshit <aruprakshit1987(at)outlook(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: SQL query problem of a Quiz program
Date: 2016-12-17 15:25:34
Message-ID: KL1PR0601MB14132728285D7C721E482939B39F0@KL1PR0601MB1413.apcprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Here is a sample data from table "quiz_results":

id | question_id | user_id
----+-------------+------------
2 | 25 | 5142670086
3 | 26 |
4 | 26 |
5 | 27 |
6 | 25 | 5142670086
7 | 25 | 5142670086
8 | 25 | 5142670086
9 | 26 |
10 | 40 | 5142670086
11 | 29 | 5142670086

As you see above question id 25 appeared more than once. This is basically a quiz result table where for users as they answered. question_id 25 always the first questions. Any user can go though the quiz N number of time. So, I want to find the last occurrence of the question_id 25 for any specific user in the table, and select that and all answers the users gave after this till the end of the quiz. Any idea how to solve it in a single efficient query. My all try didn't work out.


--------------------
Regards,
Arup Rakshit

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2016-12-17 16:02:40 Re: SQL query problem of a Quiz program
Previous Message Kevin Grittner 2016-12-17 14:08:54 Re: [GENERAL] Love Your Database project — Thoughts on effectively handling constraints?