请问怎样用语句查询出一个中的两条重复记录？急....

Question

表R107 有列 A 、 B
            a    2
            b    3
            a    2请问怎样查询能得出 RESULT: a  2
                           a  2

Answer 1

lz举个例子SQL> select * from test00;USERNAME                    PAY
-------------------- ----------
mikle_22                    800
mikle                       500
mikle                       500SQL> select   *   from  test00 A   where   username   in   (select   username   from   test00 A   group   by   username   having   count(*)>1)
  2  /USERNAME                    PAY
-------------------- ----------
mikle                       500
mikle                       500
换成你对应的字段即可

Answer 2

select * from R107 where a in (select a from R107 group by a having count(*)>1);

Answer 3

select a.*
  from os_step_parameter a
 where (select count(parametername) from os_step_parameter b where
 a.parametername = b.parametername
   and a.wfname = b.wfname) > 1