CODEWITHSUNDEEP
sqlsql-server-2008
user3337695
user3337695

Reputation: 1

SQL query with minus and joins

I have three column names, all in one table. Which returns 96 rows. Im trying to use a Minus statement and Join statement to see if there are any duplicates in the database/other tables. The 3 columns are in 3 seperate tables so i am trying to use a Minus and Join statement to get a number of rows that are duplicates. Can anyone help? First time user.

Upvotes: 0

Views: 119

Answers (1)

Kenan Zahirovic
Kenan Zahirovic

Reputation: 1597

AFAIK, SQL Server does not support MINUS. Use EXCEPT instead.

Upvotes: 1

Related Questions