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

How would you pass hints to the sql processor?

980

how to start mysql server? : Sql dba

1195

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1005

Explain polymorphism in pl/sql.

1113

What are tables and fields?

1027

what is a database? : Sql dba

1162

what is row? : Sql dba

1224

What is sql table?

963

What is the difference between cluster and non-cluster index?

1105

What is acid property in a database?

1031

what is oltp (online transaction processing)? : Sql dba

1072

Does a primary key have to be a number?

963

How many developers work on postgresql?

975

Can there be more than one function with a similar name in a pl/sql block?

979

how to select unique records from a table? : Sql dba

1111