SQL - find max D value of distinct ID

Question

Pk ID D 1 2 20 2 3 46 3 2 23 4 3 56 5 4 55 6 4 12 find max D value of distinct ID

Upendra Pratap Shahi · Answer

Hello Avinash Vajpayee  Use below query- select MAX ( D ) as D  ID from TestTable group by ID See step to produce- step1- Step 2- Your requirement output- if this helpful kindly accept the answer.

Manas Mohapatra · Answer

select MAX(D) ID from table group by ID

Sumit Joshi · Answer

Hi Avinash Try the Query below select PK ID(MAX)D from table where ID in (select dictinct ID from table) If find helpful Mark as Correct Answer