If the table is salary.then SELECT * FROM salary ORDER BY income DESC LIM

how to retrive only second row from table?

Question Posted / sudip chatterjee

Answer Posted / sudip chatterjee

If the table is salary.then
SELECT * FROM salary ORDER BY income DESC LIMIT 1, 1;
here income is one attribute of salary table......
just use it.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Define union, minus, union all, intersect ?

1010

What are the subsets of sql?

1136

How to download oracle sql developer?

1113

What are the different parts of a package?

1115

What is the difference between nested table and varray?

1006

What are the most important characteristics of pl/sql?

1161

What is a record in a database?

1065

define join and explain different type of joins? : Sql dba

954

How do I filter in sql profiler?

999

What is crud diagram?

952

Is sql a backend language?

1100

differentiate between float and double. : Sql dba

1060

How do I restart sql?

979

what are the 'mysql' command line arguments? : Sql dba

1144

What are the types of join and explain each?

1051