Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 116115 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / tejasvita dhuri
select id,salary from (select id,salary,ROW_NUMBER()over (order by salary desc) as rowcol from emp)A
where A.rowcol=2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are dml commands?
what is data control language? : Sql dba
What is acid property in a database?
What will you get by the cursor attribute sql%rowcount?
Why do we need pl sql?
What is case function?
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????
Which one is better subquery or joins?
How do you go back in sql?
What are the key differences between SQL and PL SQL?
Is pl sql different from sql?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is sql rowcount?
What is right join in sql?
What are % type and % rowtype?
