๐Ÿ—‚๏ธ DataBase

1๊ฐœ์˜ ์ปฌ๋Ÿผ์˜ ๋Œ€ํ•œ ์ค‘๋ณต ๊ฐ’ ํ™•์ธ select u.name, count(u.name) from users u group by u.name having count(u.name) > 1; 2๊ฐœ ์ด์ƒ ์ปฌ๋Ÿผ์˜ ๋Œ€ํ•œ ์ค‘๋ณต ๊ฐ’ ํ™•์ธ select u.cell_phone, u.name, count(*) from users u group by u.cell_phone, u.name having count(*) > 1;
์• ์ •์“ฐ
'๐Ÿ—‚๏ธ DataBase' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๊ธ€ ๋ชฉ๋ก