select min(salary) as salary from Employee where salary

How to find 6th highest salary from Employee table ?

Question Posted / manikanta

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

Please Help Members By Posting Answers For Below Questions

Define the one-to-one relationship while designing tables.

883

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2042

What is an indexing technique?

906

What stored by the master?

936

what do you understand by change data capture?

977

Describe triggers features and limitations?

964

Explain what are commit and rollback in sql?

908

Why do you want to join software field as you have done your BE in Electronics?

2128

What is a heap?

1020

What is mean by candidate key?

988

What is Cross Join and in which scenario do we use Cross Join?

1001

Explain the usage of floor function in sql server.

942

What are the steps to process a single select statement?

921

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?

1076

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1125