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 sqlite format?

1207

What is difference between pl and sql?

1071

What are the properties of a transaction?

1130

What is pl sql in dbms?

956

What are records give examples?

1016

How do you write an inner join query?

962

What is a sql*loader control file?

1274

How to call shell script from pl sql procedure?

1290

Is it mandatory for the primary key to be given a value when a new record is inserted?

1206

What is cursor and its types?

1083

How do you know if a relationship is 2nf?

955

What do you mean by stored procedures?

1021

How do I know if I have sql express or standard?

1043

How do I pipe the output of one isql to another?

1010

how does a local variable is defined using t-sql? : Transact sql

1027