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 the mutating table and constraining table?

1077

What does (*) mean in sql?

1000

Is it important to partition hard disk?

1067

What is restrict in sql?

1177

What are the 3 types of behavioral triggers?

1311

Why do we use sqlite?

1027

what are date and time data types in mysql? : Sql dba

1020

how to enter numeric values as hex numbers? : Sql dba

1099

Explain the difference in execution of triggers and stored procedures?

1060

How do I remove sql plus from windows 10?

1142

tell me about various levels of constraint. : Sql dba

1071

Is sql better than excel?

1224

What is the purpose of my sql?

1008

difference between anonymous blocks and sub-programs.

1188

discuss about myisam key cache. : Sql dba

1067