getting the max number and show the row

this

SELECT id,Name,Num
FROM MyTbl m
WHERE NOT EXISTS (
SELECT 1
FROM MyTbl
WHERE id = m.id
AND Num > m.Num
)

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c