SELECT sal FROM table_name ORDER BY sal DESC LIMIT(99,1);

how to findout the 100th maximum salary

Question Posted / gani

Answer Posted / gani

SELECT sal FROM table_name
ORDER BY sal DESC
LIMIT(99,1);

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we use having without group by in sql?

732

What is the use of index in sql?

761

What does cursor do in sql?

712

What does inner join mean?

756

Enlist the advantages of sql.

742

Do we need commit after truncate?

811

How do I run a sql trace?

692

What is a crud api?

682

Does sql*plus also have a pl/sql engine?

759

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

958

What is trigger in pl sql with examples?

716

Is delete faster than truncate?

747

Define join and name different types of joins?

712

What is nvarchar in sql?

713

How to handle bulk data?

1050