how to find the second highest salary from emp table?
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 |
Post New Answer View All Answers
what are the differences between char and varchar? : Sql dba
How to create an array in pl/sql?
How do I remove sql plus from windows 10?
What are inbuilt functions in sql?
What is number function in sql?
Define join and name different types of joins?
how to use like conditions? : Sql dba
What is a left inner join?
What are analytic functions in sql?
How do you modify a trigger?
What are sql commands?
What is the primary use of normalization?
What does truncate mean in sql?
How do I clear the screen in sql plus?
what is the bond code in materialized view?