Interested to Buy Any Domain ? << Click Here >> for more details...
write query for fourth maximum salary from employee table
- 14 Answers
- 24316 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
Explain the usage of floor function in sql server.
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What is the difference between a stored procedure and a user defined function?
How can we solve concurrency problems?
What is buffer cash and log cache in sql server?
What is lock escalation? : sql server database administration
What is cursors?
List the types of recovery model available in sql server?
How can you ensure that the database and sql server based application perform well?
What is 2nf normalization form?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Explain about extended stored procedure?
When I delete any data from a table, does the sql server reduce the size of that table?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
