Hello Friend, how to find distinct MAx record no in sql server. ex: sr no. id name 1 1 a 2 2 b 3 3 c 4. 1 a1 5 1 a2 result: srno, id, name 2 2 b 3 3 c 5 1 a2 ...