selectename,sal from (select ename,sal from emp order by sal desc) where r

how to find the second highest salary from emp table?

Question Posted / ramu

Answer Posted / ramu

selectename,sal from (select ename,sal from emp order by sal
desc) where rownum<=5;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why do we create views in sql?

1218

How do I run a sql query in pgadmin 4?

1000

What is the main reason behind using an index?

1059

What do you mean by rowid?

1023

Is sql port 1433 encrypted?

1086

What is the primary use of normalization?

1053

What is field delimiter?

1112

What is lookup table in sql?

1092

What is a table partition?

1205

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1043

Does truncate release storage space?

1136

What is the most important ddl statements in sql are?

1042

What is difference between db2 and sql?

1046

What are sql*plus environment variables?

1155

Which sql statement is used to delete data from a database?

1007