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 declare a constant?

911

What is query syntax?

915

How to order siblings in oracle hierarchy queries?

983

What is left inner join in sql?

986

What is the difference between the implicit and explicit cursors?

995

Why do we use set serveroutput on?

927

What is graph sql?

938

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

972

how to extract a unit value from a date and time? : Sql dba

948

What are the events on which a database trigger can be based?

1104

What is procedure in pl sql?

982

Can delete statement be rollbacked?

935

What has stored procedures in sql and how we can use it?

1019

How much does sql cost?

933

how would concatenate strings in mysql? : Sql dba

1017