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

Why is the cursor important?

1002

Why functions are used in sql?

955

What is sql lookup?

881

what are the authentication modes in sql server? How can it be changed? : Sql dba

1353

What is pragma in sql?

1038

What is scalar function in sql?

1000

What is the use of %rowtype?

999

What is the purpose of primary key?

979

How do I find sql profiler?

898

what is a relationship and what are they? : Sql dba

1055

What is the difference between python and sql?

951

Show the cursor attributes of pl/sql.

1018

Is it important to partition hard disk?

979

How do you delete data from a table?

990

What is query optimization in sql?

951