Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102592 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / swapnil tikale
Select top 1 salary from (select distinct top 2 salary from employee order by salary desc) as sal order by salary ;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is primary key and unique key?
What are character functions?
what is offset-fetch filter in tsql? : Transact sql
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Is sql difficult?
What is the use of non clustered index?
How to install oracle sql developer?
What are the types of variable use in pl sql?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is rank function in sql?
Can we call stored procedure in function?
Can we join two tables without common column?
what is unique key constraint? : Sql dba
What is the difference between left and left outer join?
How many types of triggers exist in pl/sql?
