select sal from emp where rownum=2 order by sal desc

how to find the second highest salary from emp table?

Question Posted / pradeep

Answer Posted / pradeep

select sal from emp
where rownum=2
order by sal desc

Is This Answer Correct ?

10 Yes

50 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of indexing?

986

What are the steps for performance tuning.

1341

Can I join the same table twice?

1054

Define commit, rollback and savepoint?

1036

What is a natural join?

1078

Mention what is the use of function "module procedure" in pl/sql?

1050

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1007

Why stored procedure is better than query?

950

Explain how to use transactions efficiently : transact sql

987

Explain isolation levels. : Transact sql

1074

What is procedure explain with example?

969

Can a composite key be null?

984

Write a query to find the names of users that begin with "um" in sql?

1002

What is primary key and foreign key?

965

how to add a new column to an existing table in mysql? : Sql dba

1076