Question

sql查询中 将查询结果只显示最后几行,怎么写

Answer 1

在语句最后加上 显示
limit n 前n行
limit n,m 第n行到第n+m行
order by colname desc limit n 后n行

Answer 2

select * from tablename where 条件 order by 列名(显示条数的依据)

Answer 3

SELECT *
FROM
(
SELECT TOP 10 *
FROM Tbl
ORDER BY Id DESC
) t
ORDER BY Id ASE

Answer 4

select top 10 * from tables order by id desc

Answer 5

select top 10 * from ....order by ..desc