how to retrive only second row from table?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to run sql*plus commands in sql developer?

598


What are the types of optimization?

529


What is a delimiter in sas?

556


What is rtm in testing?

585


How to get list of all tables from a database?

647






Can cursors be part of a trigger body?

1131


Can we call procedure in select statement?

533


What is sqlerrm?

559


What is cursor explain with example?

567


What is PL/SQL Records?

640


Explain alias in sql?

594


What is application trigger?

552


What is structural independence and why is it important?

559


What are all the ddl commands?

646


What are the types pl/sql code blocks?

623