Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102877 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / nagarjuna.reddy
select max(sal) from emp where sal <> (select max(Sal) from
emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the working of primary key?
How do you modify a trigger?
Does mysql_real_escape_string prevent sql injection?
Why do we need view in sql?
What is primary key in db?
what is the command used to fetch first 5 characters of the string? : Sql dba
What are the most important ddl statements in sql?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is materialized view in sql?
What are schema-level triggers?
Which is better join or subquery?
how to get a list of indexes of an existing table? : Sql dba
What is function and procedure?
Why we use triggers in mysql?
What is normalization sql?
