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


Please Help Members By Posting Answers For Below Questions

What is the difference between a function and a trigger?

766


What is the tcp/ip port on which sql server runs?

748


What is the difference between delete and truncate statements?

746


What's new in sql management studio for sql server? : sql server management studio

766


Can you name some of the dml commands in sql?

754






What is raid and what are different types of raid levels?

779


What is join and name different type of joins?

774


What are the types of joins in sql?

773


What is trigger explain with program?

708


What is model database in sql server?

779


What happens if strings are casted into wrong code pages in ms sql server?

824


How to create dbo table in sql server?

696


What is the default port for SQL Server over a firewall?

783


Can a unique index be created on a column, which contains null?

713


on line cluster can we make if yes tell me the procedure

1739