从数据库中提取最新的十条纪录的sql语句

从数据库中提取最新的十条纪录的sql语句
---------------------------------------------------------------

SELECT TOP 10 *
FROM table1
---------------------------------------------------------------

你的数据表中加个时间字段wtime,内容就是提交的时间。

这样你取的时候就按照时间顺序来去就行了
---------------------------------------------------------------

要求数据库有时间记录字段
如sqlsvr
select top 10 * from xx order by strdate desc
oracle
select * from xx order by strdate desc
where rownum<=10
---------------------------------------------------------------

SELECT TOP 10 *
FROM table1
order by id desc

Published At
Categories with Web编程
Tagged with
comments powered by Disqus