Advertisement
juliarnasution

data duplicate pilih field

Sep 23rd, 2019
867
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.10 KB | None | 0 0
  1. SELECT
  2.     nilai1
  3. FROM
  4.     test_null
  5. WHERE
  6.     test_id = '1'
  7. GROUP BY
  8.     nilai1
  9. HAVING
  10.     COUNT(nilai1) > 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement