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
18079 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 rank function in sql?

965

What is the difference between pl and sql?

1039

What language is oracle sql developer?

941

What is the starting oracle error number?

999

How do you create a unique index?

992

What are views in sql?

928

Does view contain data?

989

How do I find duplicates in a single column in sql?

954

What is difference between hql and native sql?

1093

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1095

Is left join faster than join?

985

how to calculate expressions with sql statements? : Sql dba

985

What is data definition language?

1048

What is the advantage of index in sql?

917

How many sql core licenses do I need?

884