Select b,d from aaa group by b,d having count(*) > 1
解决方案 »
- 急!SQL Server 2008 Reporting Service导出 CSV时候显示分页符
- 请教一个SQL写法
- 数据表增加很快,急,望解答
- 关于多表球和查询的问题,极其难,至少我认为
- 帮朋友问个 取当前日期的问题
- Mssql2008如何设置主键Id奇数或偶数递增
- 如何用sql语句实现字符串连接?
- 关于OLAP的一个问题(急)
- 出勤时间统计?
- 作业自动调用存储过程出错,怎样记录详细的错误信息?
- 如何在一个查询中嵌套另一个子查询关输出为一个结果集?
- 谁能够告诉我这样一句教本作用???SELECT 'Index Name' = i.name, 'Statistics Date' = STATS_DATE(i.id, i.indid) FROM sysobjects o, s
Select t1.* from aaa t1
join (
Select b,d from aaa group by b,d having count(*) > 1
) t2 on t1.b = t2.b and t1.d = t2.d
where b in (Select b from AAA group by b,d having count(*) > 1)
and d in (Select d from AAA group by b,d having count(*) > 1)
having count(b)>1 )