write query for fourth maximum salary from employee table
Answer Posted / elumalai.k
select salary from employee aa
where 4=(select count(*)from employee bb
where aa.salary<=bb.salary)
Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is the difference between a function and a trigger?
What is the tcp/ip port on which sql server runs?
What is the difference between delete and truncate statements?
What's new in sql management studio for sql server? : sql server management studio
Can you name some of the dml commands in sql?
What is raid and what are different types of raid levels?
What is join and name different type of joins?
What are the types of joins in sql?
What is trigger explain with program?
What is model database in sql server?
What happens if strings are casted into wrong code pages in ms sql server?
How to create dbo table in sql server?
What is the default port for SQL Server over a firewall?
Can a unique index be created on a column, which contains null?
on line cluster can we make if yes tell me the procedure