Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118290 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
Which is faster truncate or drop?
What is a common use of group by in sql?
What is server name sql?
What is sequence in sql?
Define the select into statement.
What is rename in sql?
What are the commands used in sql?
How exception is different from error?
what is the difference between char_length and length? : Sql dba
What is the difference between subquery and correlated query?
Can we update views in sql?
How to load data with sql*loader?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
what is acid property in database? : Sql dba
Why do we go for stored procedures?
