What is use of except clause? How does it differ from not in clause?
- 1 Answers
- 1096 Views
- I also Faced
- E-Mail Answers
Answer Posted / Ankush Gupta
The EXCEPT clause in SQL Server is used to exclude rows that appear in the right query, but not in the left query. In other words, it returns only the differences between two result sets. The NOT IN operator also compares rows from one table with another, but it does not require the exact order of the results.nnExample: Using EXCEPT:nSELECT ProductID FROM Orders WHERE ProductID NOT EXISTS (SELECT ProductID FROM OrderDetails);nExample using NOT IN:nSELECT * FROM Customers WHERE CustomerID NOT IN (SELECT CustomerID FROM Orders)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is standby servers? Explain types of standby servers.
Explain system functions or built-in functions? What are different types of system functions?
Does view occupy space?
What is normalization and what are the advantages of it?
How can we solve concurrency problems?
How can you append an identity column to a temporary table?
Can one drop a column from a table?
What is subquery? Explain the properties of a subquery?
What are the different types of subquery?
What is the difference between upgrade and migration in sql server?
How to remove duplicate rows from table except one?
What is sql server query analyzer?
Disadvantages of the indexes?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
what is the Ticketing tool used in Wipro technologies at Bangalore...???
