求一句SQL语句.在线等

[net535]

pym name
a 1
a 2
b 4
n 5
d 4
b 6


结果
pym name
a 1
a 2
b 4
b 6


怎么得到?

[friendliu]

select pym,name from tablename where pym='a' or pym='b';

[friendliu]

select pym,name from tablename where pym='a'
union pym,name from tablename where pym='b';

[am2004]

select * from tablename where pym='a' or pym='b'

楼主是不是没有表达到位？

[net535]

我倒,不是针对这二个值.而是针对PMY有相同的都显示出来.

[lsxaa]

select * from t a where (select count(*) from t where pym=a.pym)>1

[net535]

to lsxaa(小李铅笔刀) :
高.我马上给你+分