请问这条SQL语句是什么错误?
请问这条SQL语句是什么错误?
select * from aaa where ljth in(select ljth from aaa group by lith having count(*)> 1);
这是从aaa表中选出字段ljth有重复的记录,是正确的.但是:我在这条语句的基础上再加个条件比如说 ljmc = 'sss ',如何写?
select * from aaa where ljth in(select ljth from aaa group by lith having count(*)> 1) and ljmc = 'sss ';ljmc是表的字段名 ,这样写是错误的.请问如何写?
[解决办法]
--试试这个--
select * from aaa t where ljmc = 'sss ' and (select count(lith) from aaa where ljth=t.ljth)> 1
