Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118816 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / deven
select top 1 salary from emp where salary <>(
select top 1 salary from emp order by salary desc) order by
salary desc
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the packages in pl sql?
what are dynamic queries in t-sql? : Transact sql
Is left join same as join?
Why do we use joins in sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What is application trigger?
What is the difference between rollback and rollback to statements?
How to connect a sql*plus session to an oracle server?
How do you concatenate in sql?
Is join same as left join?
which operator is used in query for pattern matching? : Sql dba
what is recursive stored procedure? : Sql dba
Why do we use function in pl sql?
What are the benefits of pl/sql packages?
What is sqlservr exe?
