Select top 2 sal from (select sal from emp order by sal desc)

how to find the second highest salary from emp table?

Question Posted / sheela

Answer Posted / sheela

Select top 2 sal from (select sal from emp order by sal
desc)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is left join example?

891

What are the dml statements?

1097

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

935

Difference between table function and pipelined function?

969

What are sql commands?

938

what are local and global variables and their differences? : Sql dba

1010

Explain the difference between rename and alias?

966

What is use of term?

1008

Explain cursor types?

957

describe transaction-safe table types in mysql : sql dba

945

How to download oracle sql developer?

1058

How many types of sql are there?

931

What is ttitle and btitle?

1006

Is sql a backend?

968

What is a clob in sql?

969