How do you retrieve the last N records from a table?

Answer Posted / manas ranjan

the RANK() and DENSE_RANK() functions can be used to
determine the LAST N or BOTTOM N rows.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scalar and vector?

523


How to get help at the sql prompt?

635


What are the parts of a sql statement?

546


What is multiple columns?

567


Is sql a scripting language?

509






What is the primary key?

532


What are the constraints available in sql?

572


How to display the records between two range in Oracle SQL Plus?

636


What is the file extension for sql database?

513


What are the possible values for the boolean data field?

512


Can we change the table name in sql?

527


what is sql in mysql? : Sql dba

568


What is trigger point?

528


Explain spool.

679


What is database white box testing and black box testing?

631