Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24839 Views
- Mind Tree, SP Software, I also Faced
- E-Mail Answers
Answer Posted / arun kumar
select top 1 e.emp_code,e.emp_name,ed.basic_salary from
employee_master e, employee_salary_detail ed where
e.emp_id=ed.emp_id order by basic_salary desc
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to create prepared statements using odbc_prepare()?
What is a covering index?
What do you mean by table and field in sql?
How to resolve the orphan use problem? : sql server security
What are different types of subquery?
Explain about system stored procedure?
What are the disadvantages of using the stored procedures?
What is a Join and explain its types?
What are the lambda triggers?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Can sql server be linked with other servers like oracle?
In what version of sql server were synonyms released?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Explain log shipping and mention its advantages.
What the different topologies in which replication can be configured?
