MySQL Forums
Forum List  »  Newbie

Re: Help with some query's
Posted by: Max Eggenhuizen
Date: November 21, 2015 05:04PM

What if i try to explain as in a query ?

SELECT * FROM PCS where PCNR = UNIQUE AND COUNT MOST USER FROM THAT PCNR

it shouldnt be that hard i think,

so that would give me

SYSTEM01 MAX UOU SOU LDATE BLABLA <-- USER MAX LOGS IN MOST OF THE TIME
SYSTEM02 PETER UOI SOU LDATE BLABLA <-- USER PETER LOGS IN MOST OF THE TIME

thats all i want,

Options: ReplyQuote


Subject
Written By
Posted
November 20, 2015 02:32PM
November 20, 2015 02:59PM
November 20, 2015 03:43PM
November 20, 2015 03:59PM
November 20, 2015 05:00PM
November 21, 2015 02:16PM
November 21, 2015 04:08PM
November 21, 2015 04:55PM
Re: Help with some query's
November 21, 2015 05:04PM
November 22, 2015 03:03AM


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.