caranya bikin id ON THE FLY... SQL SERVER SELECT telp, nama FROM (SELECT row_number() over(PARTITION BY telp ORDER BY telp) as id, telp, nama FROM DATA WHERE telp in(SELECT telp FROM data GROUP BY telp HAVING count(telp)>1) ) as a WHERE id = MAX(id) ORDER BY nama untuk SQL yang lain goog
