how to find the second highest salary from emp table?
Answer Posted / raja
first find third maximum
then it ll be very easy to find second maximum.. :)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between cursor and trigger?
What is pls_integer in pl sql?
what is primary key? : Sql dba
What is the difference between microsoft access and sql server?
What is an index in sql with example?
What is a unique key?
How to run sql functions in pl/sql?
What is sql profiling in oracle?
what is a cursor? : Sql dba
How do we use distinct statement? What is its use?
What is a primary key called that is made up of more than one field?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is left join in postgresql?
What is the difference between microsoft access and sql?
what is the command used to fetch first 5 characters of the string? : Sql dba