Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102935 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / swapnil tikale
Select top 1 salary from (select distinct top 2 salary from employee order by salary desc) as sal order by salary ;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I run a pl sql procedure in sql developer?
Can one improve the performance of sql*loader? : aql loader
How many sql are there?
How to make a copy values from one column to another in sql?
Is there a way to automate sql execution from the command-line, batch job or shell script?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
define data blocks ? : Sql dba
What are local and global Indexes and where they are useful.
How do you truncate?
How do you use collections in procedure to return the resultset?
What is insert command in sql?
What type of database is sql?
What is the use of non clustered index?
Which is better cte or subquery?
What is dml and ddl?
