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
What is database black box testing?
Define constraints and give an example of their use?
How do you use a subquery to find records that exist in one table and do not exist in another?
Suggest a method of joining two tables.
What is sleeping status in sql server?
How you can get a list of all the table constraints in a database? : Sql server administration
What is sqlcmd?
What is DCL?
What is the difference between seek predicate and predicate?
How we can compare two database data?
What is sql server database?
What are different types of table joins?
Explain what are the database objects? : SQL Server Architecture
what are the different ways to return the rowcount of a table?
Detail about the hardware which is supported by SQL server?