34,577
社区成员
发帖
与我相关
我的任务
分享请问哪里错了？
CREATE PROCEDURE GetSMSSTop3
/*
(
@parameter1 datatype = default value,
@parameter2 datatype OUTPUT
)
*/
AS
SELECT TOP 3 * FROM SMSS WHERE Topic = 'ST' ORDER BY CODate DESC
UNION
SELECT TOP 3 * FROM SMSS WHERE Topic = 'SL' ORDER BY CODate DESC
UNION
SELECT TOP 3 * FROM SMSS WHERE Topic = 'CM' ORDER BY CODate DESC
/* SET NOCOUNT ON */
RETURN
/*
(
@parameter1 datatype = default value,
@parameter2 datatype OUTPUT
)
*/
AS
SELECT TOP 3 * FROM SMSS WHERE Topic = 'ST' ORDER BY CODate DESC
UNION
SELECT TOP 3 * FROM SMSS WHERE Topic = 'SL' ORDER BY CODate DESC
UNION
SELECT TOP 3 * FROM SMSS WHERE Topic = 'CM' ORDER BY CODate DESC
/* SET NOCOUNT ON */
RETURN
...全文
请发表友善的回复…
发表回复
stevegates 2003-08-25
- 打赏
- 举报
是不是union的每个字句不能包含order by?那我要怎么实现呢？
