Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120178 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / naresh kumar kalangi
select top 1 * from (select top 2 * from emp order by sal
desc)s order by sal
| Is This Answer Correct ? | 5 Yes | 8 No |
Post New Answer View All Answers
what is the difference between nested subquery and correlated subquery?
what are string data types? : Sql dba
What is a call statement? Explain with an example.
How many types of triggers are there in pl sql?
How many types of cursors are available in pl/sql?
define data blocks ? : Sql dba
In a distributed database system, can we execute two queries simultaneously?
How do I save a sql query?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is dense_rank in sql?
What is on delete restrict?
Why are indexes and views important to an organization?
Explain the components of sql?
What is inner join in sql?
How do you clear the screen in sql?
