SQL语句问题? SELECT COUNT(*) FROM table where xh = 'xxx'如果结果大于1, 就表明有重复的字段值 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select count(xh) as 重复数,xh from Tgroup by xh select * from (select count(*) as cnt,xh from Tgroup by xh) awhere a.cnt>1 select * from yourtable where (select count(xh) from yourtable)>1 select xh from yourtable group by xh having count(xh)>1 如果想显示所有学号为重复记录的话则:select * from yourtable where xh in(select * from student where (select count(id) from student)>1) 数据库编程提升 问一个弱智的问题 怎样计算两个时间的差 生成创建表脚本问题 sql内如何设置自动id 求這個視圖.100分.解決了就給分. 在sql中如何实现象EXCEL中的这个计算公式,哪位大佬能帮忙解决这个问题,100分送上,不够再加! 这个表怎么设计 请教怎样编程将远程的SQL SERVER数据库转存到本地的paradox数据库? 数据库 关于数据的存取 SQL Server 2000企业版 能是WIN2000专业版 上安装吗?
group by xh
(
select count(*) as cnt,xh from T
group by xh
) a
where a.cnt>1
select * from yourtable where xh in(select * from student where (select count(id) from student)>1)