WRITE A SQL QUERY TO FIND RECORDS IN TABLE Q THAT ARE NOT IN TABLE R WITHOUT USING NOT IN OPERATOR IN ORACLE SQL

 INTERVIEW FREQUENTLY ASK QUESTION AND SOLUTION:

 USING ------->. MINUS OPERATOR

CREATE TABLE TABLE_Q

(  

    EmployeeID int,

    FirstName varchar(50) NOT NULL,  

    LastName varchar(50) NOT NULL

);

INSERT INTO TABLE_Q(EmployeeID,FirstName, LastName)

VALUES(20,'AMIT','SING');

SELECT * FROM TABLE_Q;

CREATE TABLE TABLE_R

(  

    EmployeeID int,

    FirstName varchar(50) NOT NULL,  

    LastName varchar(50) NOT NULL

);

INSERT INTO TABLE_R(EmployeeID,FirstName, LastName)

VALUES(30,'AJAY','GOND');

SELECT * FROM TABLE_R;

SELECT * FROM TABLE_Q

MINUS

SELECT * FROM TABLE_R;