select ename,sal from (select ename,sal,row

how to find the second highest salary from emp table?

Question Posted / debasish

Answer Posted / debasish

select ename,sal from (select ename,sal,row_number()
over(order by sal desc)rn from emp)
where rn=1;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is an index in sql with example?

1022

How do you create a unique index?

1094

What is PL/SQL Records?

1257

What is ttitle and btitle?

1116

When you have to use a default "rollback to" savepoint of plvlog?

1252

What is $$ in sql?

1046

How do I remove sql developer from windows 10?

1185

what are the advantages a stored procedure? : Sql dba

1021

How to select random rows from a table?

1136

what is dbms? : Sql dba

1036

How does postgresql compare to mysql?

1080

how many values can the set function of mysql take? : Sql dba

1039

What do you understand by pl/sql packages?

1107

how to shutdown mysql server? : Sql dba

1147

Enlist the advantages of sql.

1054