SELECT A.SAL FROM EMP_TAB A WHERE 1=(SELECT COUNT(*) FROM EMP

how to calcuate the second highest salary of he employee

Question Posted / hari krishna j

13 Answers
18564 Views
Synechron, I also Faced
E-Mail Answers

Answer Posted / hari krishna j

SELECT A.SAL FROM EMP_TAB A
WHERE 1=(SELECT COUNT(*) FROM EMP_TAB B
WHERE B.SAL > A.SAL)

Change value of 1 if
0 - First heighest sal
1 - Second " "
2 - Third heighest sal
.
.
.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is transaction? : Sql dba

1008

Is sql similar to python?

976

How do you know if a relationship is 2nf?

946

How many types of privileges are available in sql?

1350

what is data manipulation language? : Sql dba

1021

What are the built in functions of sql?

1030

What is a schema sql?

1157

what is a cursor? : Sql dba

1024

what are the advantages a stored procedure? : Sql dba

977

What is the current version of sql?

1023

What is normalization in a database?

1159

Is sql open source?

979

What are the different operators available in sql?

1001

what happens if you no create privilege in a database? : Sql dba

1001

What is the difference between the conventional and direct path loader? : aql loader

1153