查询表并输出前25列用sql语句怎么说

查询表并输出前25列用sql语句怎么说
2025-02-27 09:00:42
推荐回答(1个)
回答1:

用两个top 内层TOP取25%再在外层取倒序的top 1

1
2
3

select top 1 * from (select top (25) percent * from GZ02 order by gz02.sfgz

) a order by sfgz desc