select sal from (select sal,rank() over(order by sal desc) as rank from em

how to get second highest salary in SQL(as/4000

Question Posted / devi

Answer Posted / devi

select sal from (select sal,rank() over(order by sal desc)
as rank from emp) where rank>1 and rank<3

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Is json a nosql?

1035

What is the difference between pl and sql?

1153

Why are indexes and views important to an organization?

1000

What is dml with example?

1156

What is the difference between a procedure and a function?

1216

What is a delimiter in sas?

1130

Why use triggers in sql?

1013

What is dml and ddl?

1011

How to get list of all tables from a database?

1212

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3624

Is sql procedural language?

1015

Can we rollback delete command?

1039

What is a sql driver?

1041

How do I find sql profiler?

992

What is normalization? How many normalization forms are there?

1141