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 concurrency control. : Transact sql

1236

What does count (*) do in sql?

1050

What is sql*plus?

1122

how to get @@error and @@rowcount at the same time? : Sql dba

1082

What are analytic functions in sql?

1074

Where can I learn sql for free?

1049

What trigger means?

1036

what is the difference between char and varchar data types? : Sql dba

1174

what is primary key? : Sql dba

1081

What does count (*) mean in sql?

1654

How many types of cursors supported in pl/sql?

1258

Are sql database names case sensitive?

1052

How to rename a table?

1074

what is the difference between a local and a global temporary table? : Sql dba

1128

What are character functions in sql?

994