How to find the distinct row of max value which have unique phone number

Asked May 04 '20 at 07:01

Active May 04 '20 at 14:29

Viewed 25 times

My table is below

Name,id,order,Phone
Ada,52,Ball,123
Ada,55,Pen,123
Ada,67,Ball,789
Mak,58,Book,345
Mak,60,Cho,345

How to get the all the rows of max value if the phone number is different

My expected out

Name,id,order,Phone
Ada,55,Pen,123
Ada,67,Ball,789
Mak,60,Cho,345

find the distinct name with id(max) having same phonenumber

edited May 04 '20 at 14:29

asked May 04 '20 at 07:01

2

Postgres or mysql? – Renato May 04 '20 at 07:04
And note that order is a reserved word in MySQL – Strawberry May 04 '20 at 07:09
You asked this question an hour ago and it was closed as a duplicate postgresql question - You haven't clarified which server you want an answer for so why should this question not be closed also? – P.Salmon May 04 '20 at 07:48
@P.Salmon its postgresql – May 04 '20 at 14:27
Shouldn't this be closed of the ultimate target Q rather than a question that's just a duplicate itself? – TylerH May 04 '20 at 19:26

0 Answers0