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

Does view contain data?

989

What is a recursive stored procedure?

1098

how to use case expression? : Sql dba

960

What are sql data types?

953

How is sql used in oracle?

971

Is sql similar to python?

919

How many types of privileges are available in sql?

1286

Is truncate ddl or dml?

945

Is like operator in sql case sensitive?

962

What are the types of keys?

935

what is the command line end user interface - mysql? : Sql dba

926

Which is faster joins or subqueries?

931

What is the purpose of using pl/sql?

1078

What is the trigger in sql?

905

Can a commit statement be executed as part of a trigger?

998