You are not logged in.

#1 2015-09-18 06:06:09

hasnain
Administrator
From: Chichawatni
Registered: 2014-10-13
Posts: 8,355
Website

SQL Table:

http://interviewquestionsanswers.org/quiz/Database http://interviewquestionsanswers.org/qu … L-Database

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

Option A):
5
Option B):
10
Option C):
9

Correct Answer is Option C):
9


Failure is the first step towards seccess.

2015-09-18 06:06:09

Advertisement
Ads By Google

Re: SQL Table:



Board footer