write query for fourth maximum salary from employee table
Answer Posted / pramod
Select Top 1 (Salary) from emp where salary not in
(select Top 3 (Salary) from emp order by salary desc)
order by salary desc
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is merge join?
What is field with example?
Give an example of SQL injection attack ?
How do you create type- insensitive operator?
What is data source in connection string?
Do you know what are the properties of the relational tables?
Explain triggers in sql?
What is the default sql server instance name?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How can you insert values in multiple rows using one Insert statement?
what's the difference between delete table and truncate table commands? : Sql server database administration
How can I change procedure name in sql server?
Can We Use Data-grids For Our Report In Ssrs?
What do you mean by normalisation?
What is the command used to check locks in microsoft sql server?