Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 116137 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / sanjib b
select last_name,salary from employees where salary =
(select max(salary) from employees
where salary <> (select max(salary) from employees))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how many sql ddl commands are supported by 'mysql'? : Sql dba
What are the operators used in select statements?
What does the argument [or replace] do?
What is the difference between joins?
Explain the rollback statement?
How do I view a sql database?
What is the advantage of index in sql?
How can you save or place your msg in a table?
What is the difference between instead of trigger and after trigger?
What does a pl/sql package consist of?
What is varray in pl sql?
How to pipe multiline string to isql?
What does sql stand for?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is the difference between an inner join and an outer join?
