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 an alias command?

1068

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1138

Can you inner join the same table?

991

What is out parameter used for eventhough return statement can also be used in pl/sql?

1077

List and explain the different types of join clauses supported in ansi-standard sql?

1356

What does dml mean?

987

What are the built in functions of sql?

1030

What is the difference between truncate and drop statements?

1189

how to convert numeric values to character strings? : Sql dba

1107

What is sql keyword?

1002

what are the advantages a stored procedure? : Sql dba

976

Does postgresql run on the cloud?

1147

How does postgresql compare to oracle/db2/ms sql server/informix?

1034

What is the maximum size of sqlite database?

1111

Why is a primary key important?

1042