mysql查詢一個表中name相同的記錄
4 回答
人到中年有點甜
TA貢獻1895條經驗 獲得超7個贊
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用于列出所有 出現2次或2次以上的名字
慕尼黑的夜晚無繁華
TA貢獻1864條經驗 獲得超6個贊
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)
添加回答
舉報
0/150
提交
取消