Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102568 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / niladri saha
into my above solution,u can get whatever position u want,only by giving "n" at the place of "2" at row num. That the right way to write the query. That u can use in dynamically.
Thanks,
like if ur require ment to print empnames of having 3rd max salary,then put 3 at rownum.
Niladri Saha.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Is sql a microsoft product?
Are subqueries faster than joins?
What is localdb mssqllocaldb?
How do I start sql from command line?
what are myisam tables? : Sql dba
what is offset-fetch filter in tsql? : Transact sql
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What is raid? How does it help storage of databases?
What trigger means?
What sql does db2 use?
What are the types of index in sql?
What is foreign key sql?
How to rename a table?
how to select first 5 records from a table? : Sql dba
What is cross join sql?
