string sqlStr = "select * from wlsg " + Conditions2 + " order by sqrq desc";一个表wlsg里每个字段都有重复记录,现在把wlsg_no字段内容重复的取出一条,
1:所有字段内容要显示出来,
2:后面还要有WHERE条件,
3:而且还要按sqrq排序,
SQL怎么写?
1:所有字段内容要显示出来,
2:后面还要有WHERE条件,
3:而且还要按sqrq排序,
SQL怎么写?
col1,col2......
from
tb
where
条件
group by
col1,col2......
having
count(1)>1
order by
sqrq desc