how to find the second highest salary from emp table?
Answer Posted / vikas
select top 1 salary from emp
where salary in (select top 2 salary from emp order by salary desc)order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does pdo prevent sql injection?
What is difference between stored procedure and trigger?
What is pls integer?
What is the advantage of nosql?
How do I run pl sql in sql developer?
How to prepare for oracle pl sql certification?
What does closing a cursor do?
What is the difference between clustered and non-clustered indexes?
What is the difference between local variables and global variables?
What does the file extension accdb stand for?
What is the difference between rollback and rollback to statements?
What are sql objects?
Does inner join return duplicate rows?
what are wild cards used in database for pattern matching ? : Sql dba
how to use like conditions? : Sql dba