本文介绍了我要查询查询表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨
有这张桌子
我的表格名称是NEWS
以及以下字段:NewsId,NewsTitle,NewsDate
想要查询
通过选择
想要选择此表的3条记录
这3条记录是按日期显示的3条最新消息
我想获取表末3条记录(结束时间3条记录,而不是结束表)
请给我一个查询解决方案
在这里: SELECT TOP 3 NewsId,NewsTitle,NewsDate FROM NEWS ORDER BY NewsDate DESC
以下命令对结果进行排序,以便最新的在顶部:
ORDER BY NewsDate DESC以下内容指示SELECT仅获取前3行:
SELECT TOP 3
您可以使用简单的技巧以升序获取最后3条记录. SELECT * FROM ( SELECT TOP 3 NewsId,NewsTitle,NewsDate FROM NEWS ORDER BY 新闻日期 DESC ) AS DT 订单 BY DT.NewsDate
hi a have this table My table name is NEWS and this fields: NewsId ,NewsTitle,NewsDate a want get a query by select a want select 3 record of this table this 3 record is 3 last news by date i want get 3 record of end of table (3 record of end time,not of end table) please give me a query
解决方案 Here you go: SELECT TOP 3 NewsId, NewsTitle, NewsDate FROM NEWS ORDER BY NewsDate DESCThe following orders the results so the newest are at the top:
ORDER BY NewsDate DESCThe following instructs the SELECT to get just the first 3 rows:
SELECT TOP 3You can use a simple trick to get last 3 records in ascending order. SELECT * FROM (SELECT TOP 3 NewsId, NewsTitle, NewsDate FROM NEWS ORDER BY NewsDate DESC) AS DT ORDER BY DT.NewsDate更多推荐
我要查询查询表
发布评论