Question:
Consider the following two tables emp1 and emp2:emp1 Id Name 1 Amit 2 Punita
emp2 Id Name 1 Punita 2 Anand
What is the output of the following query?
SELECT name from emp1 minus SELECT name from emp2;
Consider the following two tables emp1 and emp2:
What is the output of the following query?
SELECT name from emp1 minus SELECT name from emp2;
| emp1 | |
| Id | Name |
| 1 | Amit |
| 2 | Punita |
| emp2 | |
| Id | Name |
| 1 | Punita |
| 2 | Anand |
SELECT name from emp1 minus SELECT name from emp2;
Updated On: Nov 4, 2024
- Punita
- Amit
- Anand
- Amit, Punita
Hide Solution
Verified By Collegedunia
The Correct Option is B
Solution and Explanation
The 'MINUS' operation returns the difference between two datasets. Here, the name "Amit" in emp1 is not present in emp2.
Was this answer helpful?
0
0
Top Questions on SQL
- Amit wants to be familiar with SQL. One of his friends Anand suggests him to execute the following SQL commands:
(A) Create Table Student
(B) Use Database DB
(C) Select * from Student
(D) Insert into Student
In which order Amit needs to run the above commands? - Which of the following is correct syntax for inserting foreign key constraint in a relation?
- What is the result of the following arithmetic operation in SQL: SELECT 5 + NULL AS RESULT?
- Which SQL expression calculates the square root of 16?
- Consider the following SQL functions:
(A) CURDATE()
(B) CURRENT DATE()
(C) CURRENT DATE
(D) TODAY()
View More Questions
Questions Asked in CUET exam
- A molecule X associates in a given solvent as per the following equation:
X ⇌ (X)n
For a given concentration of X, the van’t Hoff factor was found to be 0.80 and the
fraction of associated molecules was 0.3. The correct value of ‘n’ is:- CUET (UG) - 2024
- Solutions
- Who devised the concept of Intelligence Quotient (IQ)?
- CUET (UG) - 2024
- Psychological attributes
- Two pipes A and B can fill a tank in 32 minutes and 48 minutes respectively. If both the pipes are opened simultaneously, after how much time B should be turned off so that the tank is full in 20 minutes?
- CUET (UG) - 2024
- Time and Work
- If \(A = \begin{bmatrix} 3 & 2 \\ -1 & 1 \end{bmatrix} \quad \text{and} \quad B = \begin{bmatrix} -1 & 0 \\ 2 & 5 \\ 3 & 4 \end{bmatrix},\)then \((BA)^T\) is equal to:
- CUET (UG) - 2024
- Matrices
- The spin-only magnetic moment of Hexacyanomanganate(II) ion is.........BM
- CUET (UG) - 2024
- Magnetic moment
View More Questions