how to find the second highest salary from emp table?
Answer Posted / nevin
select min(salary) from (select top 2 sal from table_name order by sal desc)salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is normalisation in sql?
How is pl sql different from sql?
What is the most common sql injection tool?
Why are indexes and views important to an organization?
How can I get the number of records affected by a stored procedure?
Can we insert delete data in view?
How many types of index are there?
What is the difference between microsoft sql and mysql?
What are three advantages to using sql?
What is the sql*loader? : aql loader
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What are the operators in sql?
Write a sql query to convert all character to uppercase after hypen.
Is it possible to sort a column using a column alias?
tell us something about heap tables. : Sql dba