Table Employee has 10 records. It has a non-NULL SALARY column which is also UNI

Question

Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.
The SQL statement
SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);
prints

Options:

A . 10

B . 9

C . 5

D . 0

Answer: Option B

Submit Your Solution Below and Earn Points !

Next Question

Submit Solution

More Questions on This Topic :

Question 1. The SQL statement SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL; prints....

Question 2. The SQL statement SELECT ROUND(45.926, -1) FROM DUAL;....

Question 3. Which of the following command makes the updates performed by the transaction permanent in the database?....

Question 4. Which of the following must be enclosed in double quotes?....

Question 5. Which command undo all the updates performed by the SQL in the transaction?....

Question 6. Find all the cities whose humidity is 89....

Question 7. What is the meaning of LIKE '%0%0%'....

Question 8. Find the temperature in increasing order of all cities....

Question 9. Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy....

Question 10. Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature m....sunny or cloudy but temperature must be greater than 70oF.

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI

Tabulation - Test Paper 2 Data Interpretation Reasoning & DI

Test Paper 1 Direction Sense Test Reasoning & DI

ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0

GFM Combined 1 Free Revision Test SAIL JO E-0

Submit Solution

More Questions on This Topic :

Latest Videos

Latest Test Papers