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

What is rowid in sql?

514

What is sql exception?

524

Explain the the delete statements in sql?

581

Is postgresql a server?

579

What are the types of join in sql?

522

What is PL/SQL Records?

631

What does select top 1 do in sql?

544

What is sql*loader and what is it used for? : aql loader

627

What is the use of sqlerrd 3?

529

Why we use cross join?

543

what does myisamchk do? : Sql dba

563

What is structural independence and why is it important?

551

What is pivot in sql?

514

What is the limitation on the block size of pl/sql?

532

How do I view a view in sql?

512