How to find 6th highest salary from Employee table ?
Answer Posted / manikanta
select min(salary) as salary from Employee where salary >
(select min(salary)from employee)
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
Explain transaction server distributed transaction?
Detail about query optimizer?
What are locks in sql?
How to override dml statements with triggers?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What are synonyms?
How network traffic be reduced by using the stored procedure?
What are parameterized reports?
What do you understand by intent locks?
List some of the rules that apply to creating and using a ‘view’
What are the reporting services components?
Why de-normalization required?
How to return the top 5 rows from a select query in ms sql server?
What is the difference between coalesce() & isnull()?
What is the command used to check locks in microsoft sql server?