SELECT TOP 1 FieldName FROM (SELECT TOP 2 FieldName FROM Tabname ORDER BY

how to find the second highest salary from emp table?

Question Posted / bell

Answer Posted / bell

SELECT TOP 1 FieldName FROM (SELECT TOP 2 FieldName FROM
Tabname ORDER BY FieldName DESC) allis ORDER BY FieldName
ASC

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the differences between char and varchar? : Sql dba

1068

How to create an array in pl/sql?

1066

How do I remove sql plus from windows 10?

1096

What are inbuilt functions in sql?

1054

What is number function in sql?

966

Define join and name different types of joins?

1006

how to use like conditions? : Sql dba

1105

What is a left inner join?

1011

What are analytic functions in sql?

1025

How do you modify a trigger?

926

What are sql commands?

1010

What is the primary use of normalization?

1002

What does truncate mean in sql?

1021

How do I clear the screen in sql plus?

1039

what is the bond code in materialized view?

3002