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
Define the one-to-one relationship while designing tables.
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
What is an indexing technique?
What stored by the master?
what do you understand by change data capture?
Describe triggers features and limitations?
Explain what are commit and rollback in sql?
Why do you want to join software field as you have done your BE in Electronics?
What is a heap?
What is mean by candidate key?
What is Cross Join and in which scenario do we use Cross Join?
Explain the usage of floor function in sql server.
What are the steps to process a single select statement?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?