Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102883 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
What is data manipulation language?
Does mysql_real_escape_string prevent sql injection?
Mention what plvcmt and plvrb does in pl/sql?
What are stuff and replace function?
Explain select statements in sql?
what is a stored procedure? : Sql dba
What is sql prepared statement?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What are all the different normalizations?
Why are indexes and views important to an organization?
Is foreign key mandatory?
Why do we need view in sql?
How to raise user-defined exception with custom sqlerrm ?
What are primary key and foreign key and how they work?
How do you create a unique index?
