select top 2 (salary) from emp order by salary desc

how to find the second highest salary from emp table?

Question Posted / bharat puri

Answer Posted / bharat puri

select top 2 (salary) from emp
order by salary desc

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why do we go for stored procedures?

1126

How to run sql*plus commands in sql developer?

1206

Write the command to remove all players named sachin from the players table.

1227

How many types of tables are there?

996

Can dml statements be used in pl/sql?

1123

Explain the advantages and disadvantages of stored procedure?

1198

What is varray in pl sql?

1120

What are the commands used in sql?

1130

how to run 'mysql' commands from a batch file? : Sql dba

1170

Explain spool.

1219

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1065

how to increment dates by 1 in mysql? : Sql dba

1030

Explain the order of sql statement execution?

1087

What is difference between stored function and application function?

1289

Which sql statement is used to return only different values?

1054