SQL Minus Clause

Tips>>SQL

MAKE FULL WEB APPLICATION WITH JUST SQL KNOWLEDGE? CLICK HERE

 

The MINUS query returns all rows in the first query that are not returned in the second query. Each SQL statement within the MINUS query must have the same number of fields in the result sets with similar data types. The MINUS operates on two SQL statements. If the second SQL statement includes results not present in the first SQL statement, such results are ignored.

 

The syntax is as follows :-

[SQL Statement 1]
MINUS
[SQL Statement 2]

EXAMPLE I :-

Table Store_Information

STORE NAME
SALES
DATE
SU RU
$1500
Jan-05-2006
THE TREND
$250
Jan-07-2006
POSITIVE
$300
Jan-08-2006
THE TREND
$700
Jan-08-2006

 

Table Internet Sales

DATE
SALES
Jan-07-2006
$250
Jan-10-2006
$535
Jan-11-2006
$320
Jan-12-2006
$750

 

We want to find out all the dates where there are store sales, but no internet sales.

We use the following SQL statement :-

SELECT Date FROM Store_Information
MINUS
SELECT Date FROM Internet_Sales

RESULT:-

DATE
Jan-05-2006
Jan-08-2006



If you don't find what you are looking for. Please click here to submit your query, our experts will reply soon.

 

 
E-mail : sales@virtualsplat.com
Phone : +91-9892413501

Whatsapp Icon +91-9967648641

Whatsapp Icon +91-9967648641