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

How do you select unique values in sql?

1003

What is the limitation on the block size of pl/sql?

987

Can we join same table in sql?

1026

What are the different dcl commands in sql?

1176

How to start the command-line sql*plus?

1058

What is the difference between delete and truncate statement in sql?

1075

What is union?

1174

How many sql statements are used?

1015

What are sql ddl commands?

1096

Does group by remove duplicates?

1046

What is cursor and its types?

1076

What is pl sql record in oracle?

1037

How do I clear the screen in sql plus?

1047

what are all different types of collation sensitivity? : Sql dba

982

What is tuple in sql?

1085