Interested to Buy Any Domain ? << Click Here >> for more details...
Query for second maximum salary in each in each department
- 15 Answers
- 37749 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 are the 'mysql' command line arguments? : Sql dba
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Explain the difference between 'between' & 'and' operators in sql
What is cte sql?
What is the requirement of self-join?
Why should I use postgresql?
What is a database event trigger?
Is merge a dml statement?
What is difference between function and trigger?
What is the use of triggers?
What is numeric function sql?
How to fetch alternate records from a table?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
what is the difference between $message and $$message? : Sql dba
Do we need to rebuild index after truncate?
