DEV Community

Nw3965
Nw3965

Posted on

Find Customer Referee

#sql

Find Customer Referee

I wanted to write SQL statements to get the information except "referee_id == 2" .

SELECT   referee_id  FROM Customer
EXCEPT  referee_id == 2
Enter fullscreen mode Exit fullscreen mode

I should select "name" to get the correct answer.

SELECT name FROM Customer
WHERE referee_id IS NULL OR referee_id <> 2;
Enter fullscreen mode Exit fullscreen mode

I learned <> is for not equal.

Top comments (0)

Read next

zhukmax profile image

Choosing the Right Database for Your Project: Beyond Personal Experience

Max Zhuk -

carlosfilho profile image

SQL vs NoSQL: Understand the difference and know when to use each!

Carlos Filho -

esproc_spl profile image

SQL, output associated records having many-to-many relationship row by row #eg26

Judy -

madgan95 profile image

SQL Complete guide for Interview

Madhav Ganesan -