sql-server - SELECT * FROM USERS 但不是我

Question

我有一个表，用于存储具有 id 的用户。如何获得除我之外的所有用户？我想我需要这样的东西:

SELECT * 
FROM USERS 
EXCEPT WHERE iduser = myiduser

Answer 1

SELECT * FROM USERS WHERE iduser != myiduser ;

或这个:

    SELECT * FROM USERS 
    except
    select * from users
    WHERE iduser = myiduser ;

或者你可以创建一个 View

Create View Everyone_else
as
SELECT * FROM USERS WHERE iduser != myiduser ;

然后用

Select * from Everyone_else ;

您可能必须为 myiduser 使用撇号，如下所示: 'myiduser'