Interested to Buy Any Domain ? << Click Here >> for more details...
Query for second maximum salary in each in each department
- 15 Answers
- 38249 Views
- DST Global Solutions, TCS, I also Faced
- E-Mail Answers
Answer Posted / arvind kumar
select * from employees e where (select count(salary) from
employees where salary >=e.salary)=2;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is multiple partition?
What is sqlite used for?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What is %rowtype in pl sql?
how to enter binary numbers in sql statements? : Sql dba
What is the location of pre_defined_functions.
What is microsoft t sql?
What is bulk collect in pl sql?
Is sql the best database?
How do we accept inputs from user during runtime?
How do I save a sql query?
What is foreign key and example?
who introduced sql?
What are the types of subqueries?
What is the importance of sqlcode and sqlerrm?
