Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24141 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
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What are “phantom rows”?
What do you mean by subquery?
How to create prepared statements using odbc_prepare()?
What is the significance of master, tempdb and model databases?
What is isnull() operator?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
What is outer join in sql server joins?
What happens when the SQL Azure database reaches Max Size?
What is log cache in sql server?
what are isolation levels? : Sql server database administration
What are the differences between ms sql server & oracle?
What is difference between equi join and inner join?
What is an indice?
What is optimistic concurrency?
