how to findout the 100th maximum salary

Answer Posted / ramu

select top(100) salary from table1 where salary not
in(select top(99) salary from table1)

Is This Answer Correct ?    1 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between hql and sql?

701


How to convert comma separated string to array in pl/sql?

812


How do I save a stored procedure?

729


explain the options of myisamchk to improve the performance of a table. : Sql dba

721


What are transaction and its controls?

738






How to combine two stored procedures in sql?

803


What is Materialized View? In What Scenario we Use Materialized View?

8939


What is a memo field?

698


What are stuff and replace function?

769


What is the sql query to display the current date?

753


How to look at the current sql*plus system settings?

763


How to write pl sql program in mysql command prompt?

711


Can we use delete in merge statement?

734


What is break?

845


How many types of primary keys are there?

710