34,587
社区成员
发帖
与我相关
我的任务
分享
select a.*
from tbMain a
where a.gzdw='良田镇'
and not exists(select 1
from tbMain b
where b.gzdw='良田镇'
and b.csny<a.csny)
select top 1 *
from tbMian
where gzdw='良田镇'
order by csny asc
SELECT *
FROM tbMain
WHERE csny IN
(
SELECT MIN(csny) csny FROM tbMain WHERE gzdw = '良田镇'
);