Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118525 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / srinivas
select max(salary) from Emp where salary<(select max(salary) from Emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a crud api?
What are the two parts of design view?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How do I turn a list into a table?
Is sqlite good enough for production?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is difference between left and right outer join?
Why do we use partitions in sql?
Is it possible to pass parameters to triggers?
What is not null in sql?
What is procedure explain with example?
what is auto increment? : Sql dba
What are two statement types in sql?
where are cookies actually stored on the hard disk? : Sql dba
What does <> sql mean?
