SELECT top 5 * FROM
(
SELECT identity(int,1,1) as ID,c.RYRD,c.FJRQ,......, FROM OUTP_YJ_BRSYK c
LEFT JOIN .....
WHERE c.HZXM = '测试666'
) m
ORDER BY m.ID DESC
sql里limit 5;
或者
SELECT TOP 5 * FROM (你现在的SQL) T
你这是sqlserver吧
select top 5 * from table order by FJRQ desc
你取的字段升序ASC,DESC降序改一下,再用TOP就用了。