Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 23940 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 is the return type of executeupdate ()?
How is SQL Azure different than SQL server?
What are clustered and non-clustered index?
Explain syntax for viewing trigger?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to use wildcard characters in like operations in ms sql server?
How do you use a subquery to find records that exist in one table and do not exist in another?
What is the difference between rank and dense_rank?
What are entities and relationships?
Does sql server use java?
What is the partitioning method?
Can we insert data into view sql server?
what is unique and xaml nonclustered index
What is sparse columns of sql server 2008?
Give me a SQL Query to find out the second largest company?
