请问这条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 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
where exists(select 1 from aaa b where a.lith=b.lith and a.主键<>b.主键)
and ljmc ='sss'
没提示错误,但我筛选的纪录不正确,
-----------
怎麼不正確了?纪录少了?