the RANK() and DENSE_RANK() functions can be used to determine the LAST N

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

Question Posted / manas ranjan

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

Please Help Members By Posting Answers For Below Questions

What is package in pl sql with an examples?

1019

How many types of triggers exist in pl/sql?

1048

What does stand for in sql?

951

What is trigger in sql? Explain

974

How to select all records from the table?

1116

what's the difference between a primary key and a unique key? : Sql dba

1030

How do I run a query in pl sql developer?

975

what are the join types in tsql? : Transact sql

1048

What is query syntax?

953

Where is pl sql used?

942

what is msql? : Sql dba

968

Is sql injection illegal?

1003

What are the qualities of 2nf?

1022

What does fetching a cursor do?

1066

How to add new employee details in an employee_details table with the following details

1078