answer_id q_id answer qscore_id answer_timestamp 1 10 Male 3 1363091016 2 10 Male 3 1363091017 3 11 Male 3 1363091018 4 10 Male 3 1363091019 5 11 Male 3 1363091020 6 12 Male 3 1363091020 7 11 Male 3 1363091025
So I have multiple answers for the same questions (q_id). I want to be able to retrieve only ONE answer per question and that be the most recent answer. There should be THREE rows returned, which are all the most recent answered for that q_id:
4 10 Male 3 1363091019 6 12 Male 3 1363091020 7 11 Male 3 1363091020
Mar 13
Ananda Kumar Re: Retrieve most recent of multiple rows
Mar 13, 2013; 19:13
Ananda Kumar
Re: Retrieve most recent of multiple rows
Mar 13
Johan De Meersman Re: Retrieve most recent of multiple rows
Mar 13, 2013; 14:49
Johan De Meersman
Re: Retrieve most recent of multiple rows
Mar 13
Ananda Kumar Re: Retrieve most recent of multiple rows
Mar 13, 2013; 19:28
Ananda Kumar
Re: Retrieve most recent of multiple rows
Mar 13
Ananda Kumar Re: Retrieve most recent of multiple rows
Mar 13, 2013; 19:35
Ananda Kumar
Re: Retrieve most recent of multiple rows
Mar 13
Johan De Meersman Re: Retrieve most recent of multiple rows
Mar 13, 2013; 15:58
Johan De Meersman
Re: Retrieve most recent of multiple rows
Mar 14
Ananda Kumar Re: Retrieve most recent of multiple rows
Mar 14, 2013; 11:49
Ananda Kumar
Re: Retrieve most recent of multiple rows
Mar 14
Ananda Kumar Re: Re: Retrieve most recent of multiple rows
Mar 14, 2013; 16:27
Ananda Kumar
Re: Re: Retrieve most recent of multiple rows
Mar 14
Johan De Meersman Re: Retrieve most recent of multiple rows
Mar 14, 2013; 16:28
Johan De Meersman
Re: Retrieve most recent of multiple rows
Mar 15
Marcus Vinicius Re: Retrieve most recent of multiple rows
Mar 15, 2013; 11:18
Marcus Vinicius
Re: Retrieve most recent of multiple rows
Mar 15
hsv Re: Retrieve most recent of multiple rows
Mar 15, 2013; 20:11
hsv
Re: Retrieve most recent of multiple rows
Mar 18
Rick James RE: Retrieve most recent of multiple rows
Mar 18, 2013; 18:00
Rick James
RE: Retrieve most recent of multiple rows
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!