w3resource

AdventureWorks Database: Fetch any distinct values from left query of EXCEPT that aren't present in the query to the right

SQL Query - AdventureWorks: Exercise-134 with Solution

134. From the following tables write a query in SQL to fetch any distinct values from the left query that aren't also present in the query to the right.

Sample table: production.Product


Click to view Full table

Sample table: production.WorkOrder


Click to view Full table

Sample Solution:

SELECT ProductID   
FROM Production.WorkOrder  
EXCEPT  
SELECT ProductID   
FROM Production.Product ;

Sample Output:

productid|
---------+	

N.B. : No result returns here

SQL AdventureWorks Editor:

Practice Online


Contribute your code and comments through Disqus.

Previous: Return any distinct values from first query, not found on the 2nd query.
Next: A distinct businessentityid must be returned by both queries.


What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.

SQL: Tips of the Day

How to avoid the "divide by zero" error in SQL?

Select Case when divisor=0 then null
Else dividend / divisor
End ,,,

OR:

Select dividend / NULLIF(divisor, 0) ...

Ref: https://bit.ly/3dLj7gS

 





We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook