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 a dirty read sql?

1243

Why is the cursor important?

1078

Explain what is a field in a database and record in a database?

1178

Why we use pl sql?

1006

What is nested table in pl sql?

1121

How do we accept inputs from user during runtime?

1116

Can a composite key be null?

1031

What is pivot query?

1120

What is sharding in sql?

1039

Explain exception handling in pl/sql?

1080

Can you rollback after commit?

1048

How do you select unique values in sql?

1047

What is the largest value that can be stored in a byte data field?

1058

What are sql objects?

1127

What are dml commands?

1073