Question

如何从SQL查询结果中取第一条满足条件记录对应的其他字段

Answer 1

select *
from tablea
where id = (select top1 id from tablea where ...);