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 write ahead logging in sql server?

990

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1042

Is it possible to create startup or shutdown trigger for on-schema?

981

How can a function retun more than one value in oracle with proper example?

1029

What is the difference between an inner join and an outer join?

971

What are the advantages of pl sql?

1074

how mysql optimizes distinct? : Sql dba

1001

How many clustered indexes can you have?

926

How can I see all tables in sql?

990

What is union and union all keyword in sql?

972

What is difference between pls_integer and integer?

910

What is data modelling in sql?

964

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

919

What are the advantages of sql?

1008

What is a unique key and primary key and foreign key?

920