语法 CREATE VIEW SQL SERVER [英] SYNTAX CREATE VIEW SQL SERVER

问题描述

我在 sql server 中创建视图并抛出错误:

i make a view in sql server and throw an error:

USE BaseDeDatos;

CREATE VIEW TEMAS_USUARIO
AS 
SELECT TOP 5 t.id_userTopic, t.nameTopic, u.id_user, u.name
FROM Topic t, Users u
WHERE t.id_userTopic = u.id_group
ORDER BY t.id_topic DESC;

语法有什么问题?错误 ---> 创建视图 TEMAS_USUARIO不能使用 LIMIT

what is wrong whit the syntax? error ---> CREATE VIEW TEMAS_USUARIO can´t use LIMIT

推荐答案

USE BaseDeDatos
GO
CREATE VIEW TEMAS_USUARIO
AS 
SELECT TOP 5 t.id_userTopic, t.nameTopic, u.id_user, u.name
FROM Topic t, Users u
WHERE t.id_userTopic = u.id_group
ORDER BY t.id_topic DESC;

SQL SELECT TOP 子句:

The SQL SELECT TOP Clause:

SELECT TOP number|percent column_name(s)
FROM table_name;

MySQL 语法

SELECT column_name(s)
FROM table_name
LIMIT number;

SQL SELECT TOP 子句解释:这里

SQL SELECT TOP Clause explanation: Here

这篇关于语法 CREATE VIEW SQL SERVER的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！