如何在一个表中找出字段相同的记录? 在线等 sele * from use where age=需要找的年龄不知道是不是你要的 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select age into #1 from use group by age having count(*)>1select * from use where age in(select * from #1) select name,age,date from usegroup by age,date,namehaving count(age)>1 select name, age, date from use a where (select sum(1) from use where age = a.age) > 1 select * from tablename where id not in (select max(id) from tablename group by col1,col2,...) select * from [use] where age in (select age from [use] group by age having sum(1)>1) 求个最简单的存储过程源码,和应用该过程的C#源码 随机数的问题 帮我看一下这个语句什么意思! sql数据库修复问题 求一个 远程同步触发器 SQL时间区间查询!!! 连接SSIS的时候提示“RPC服务器不可用”? 帮忙看看这个SQL语句 关于利用公式字段再进行公式的办法?/ 一个小有难度的问题? vb与数据库的连接 求一sql语句,谢谢
select * from use where age in(select * from #1)
group by age,date,name
having count(age)>1