select * from (select rownum r,a.* from (select distinct sal from emp ord

how to find the second highest salary from emp table?

Question Posted / prasanthi

Answer Posted / prasanthi

select * from (select rownum r,a.* from (select distinct
sal from emp order by sal desc)a)where r=&i

sql>enter i value(enter manually) 2

Is This Answer Correct ?

54 Yes

62 No

Please Help Members By Posting Answers For Below Questions

What is sqlerrm?

929

Explain constraints in sql?

1041

What is a full join?

968

What are the different dml commands in sql?

1168

How delete all data from all tables in sql?

944

What is a pragma statement?

1262

How exception is different from error?

1014

What is view? Can we update view

1430

What is the advantage of nosql?

1061

How do you create a db file?

1011

Explain the uses of database trigger.

1112

What is mutating sql table?

1104

what is an alias command? : Sql dba

1102

What are the most important characteristics of pl/sql?

1151

what is the use of double ampersand (&&) in sql queries?

1171