mysql查詢(xún)一個(gè)表中name相同的記錄
4 回答
人到中年有點(diǎn)甜
TA貢獻(xiàn)1895條經(jīng)驗(yàn) 獲得超7個(gè)贊
select name,id,age from table_name where name in (select name from table_name group by name having count(*)>1) order by name;
select name from table_name group by name having count(*)>1用于列出所有 出現(xiàn)2次或2次以上的名字
慕尼黑的夜晚無(wú)繁華
TA貢獻(xiàn)1864條經(jīng)驗(yàn) 獲得超6個(gè)贊
select * from 表 where n_id in
(select s_name from 表
group by s_name,n_money,s_zhipiao,s_date,s_lixi
having count(s_name)>1)
添加回答
舉報(bào)
0/150
提交
取消