在一表中有不少姓名重复，用下面的命令为什么查不到结果？


select * count(*) from bmk5 group by xm having count(*)>1

select * from bmk5  a order by xm where exists (select * from bmk5  b where b.xm==a.xm group by xm having count(*)>1) into cursor temp


[ 本帖最后由 lygcw9603 于 2012-5-5 02:25 编辑 ]

谢谢!
1、select * from bmk5  a order by xm where exists (select * from bmk5  b where b.xm==a.xm group by xm having count(*)>1) into cursor temp  &&此句代码的含义是什么？


2、为什么下句代码查不出结果吗？
select * count(*) from bmk5 group by xm having count(*)>1

SELECT * FROM bmk5 WHERE xm IN (SELECT xm FROM bmk5 GROUP BY xm HAVING  count(*)>1) order by xm