文章正文

大侠帮忙，这个视图该如何写捏？

类型：转载责任编辑：asp.net 日期：2007/05/23

热门软件下载：

SELECT TOP 1 * FROM MessageBoardTb WHERE boardId = 1 ORDER BY lastArgueDate DESC
SELECT TOP 1 * FROM MessageBoardTb WHERE boardId = 10 ORDER BY lastArgueDate DESC
SELECT TOP 1 * FROM MessageBoardTb WHERE boardId = 2 ORDER BY lastArgueDate DESC
SELECT TOP 1 * FROM MessageBoardTb WHERE boardId = 4 ORDER BY lastArgueDate DESC
SELECT TOP 1 * FROM MessageBoardTb WHERE boardId = 5 ORDER BY lastArgueDate DESC
SELECT TOP 1 * FROM MessageBoardTb WHERE boardId = 6 ORDER BY lastArgueDate DESC

这是6个查询语句，我的目的是它做为一个视图存在，程序里面直接读取这个视图，得到6条记录。我是新手，请大家帮忙

网友回答：

发表者：mgsray

SELECT TOP 1 * FROM MessageBoardTb WHERE boardId = 1 ORDER BY lastArgueDate DESC union all
SELECT TOP 1 * FROM MessageBoardTb WHERE boardId = 10 ORDER BY lastArgueDate DESC union all
SELECT TOP 1 * FROM MessageBoardTb WHERE boardId = 2 ORDER BY lastArgueDate DESC union all

SELECT TOP 1 * FROM MessageBoardTb WHERE boardId = 4 ORDER BY lastArgueDate DESC union all

SELECT TOP 1 * FROM MessageBoardTb WHERE boardId = 5 ORDER BY lastArgueDate DESC union all

SELECT TOP 1 * FROM MessageBoardTb WHERE boardId = 6 ORDER BY lastArgueDate DESC

发表者：hdhai9451

表的結構要一樣﹐然后用union all 或union 連接起來

热门推荐笔记本： IBM笔记本

笔记本相关：

IT技术文章：