You are not logged in.

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

husnain
User RankUser RankUser RankUser RankUser RankUser Rank
Administrator
From: Chichawatni,Pakistan
Registered: 2014-10-03
Posts: 8,129
Website

SQL Statement:

Database Quizzes SQL

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 > ALL (SELECT SALARY FROM EMPLOYEE);
prints

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

Correct Answer is Option C):
0


You cannot discover the new oceans unless you have the courage to lose the sight of the shore.

2015-09-18 06:45:21

Advertisement
Ads By Google

Re: SQL Statement:



\n

Board footer