MySQL :: Re: Select row with highest "pass" number, where user ID is the same in each row

New Topic

Re: Select row with highest "pass" number, where user ID is the same in each row

Posted by: Ryan John
Date: August 25, 2014 11:31AM

Hi Peter,

Sorry for the lack of clarification.

It would be: equal to the highest pass for that user. Such that the highest pass for each user is selected to return the specific row, for each usr with the usr_id and points.

Hope this helps make my question more clearer.

Kind Regards,

Ryan

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

Select row with highest "pass" number, where user ID is the same in each row

Ryan John

August 25, 2014 05:57AM

Re: Select row with highest "pass" number, where user ID is the same in each row

Peter Brawley

August 25, 2014 09:29AM

Re: Select row with highest "pass" number, where user ID is the same in each row

Ryan John

August 25, 2014 11:31AM

Re: Select row with highest "pass" number, where user ID is the same in each row

Peter Brawley

August 25, 2014 11:55AM

Re: Select row with highest "pass" number, where user ID is the same in each row

Ryan John

August 25, 2014 12:12PM

Re: Select row with highest "pass" number, where user ID is the same in each row

Peter Brawley

August 25, 2014 03:01PM

Re: Select row with highest "pass" number, where user ID is the same in each row

Ryan John

August 26, 2014 11:33AM

Re: Select row with highest "pass" number, where user ID is the same in each row

Peter Brawley

August 26, 2014 12:10PM

Re: Select row with highest "pass" number, where user ID is the same in each row

Ryan John

August 26, 2014 12:16PM

Re: Select row with highest "pass" number, where user ID is the same in each row

Ryan John

August 26, 2014 11:35AM

Re: Select row with highest "pass" number, where user ID is the same in each row

Peter Brawley

August 26, 2014 12:11PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.