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 a sql select statement?

1045

what is top in tsql? : Transact sql

1137

What is the use of <> sql?

986

Explain the difference in execution of triggers and stored procedures?

1028

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3581

What is difference between rank () row_number () and dense_rank () in sql?

1119

what is 'trigger' in sql? : Sql dba

1096

How do I truncate a sql log file?

1087

Which command is used to call a stored procedure?

1012

What is mutating trigger?

1032

What is the main reason behind using an index?

1029

describe mysql connection using mysql binary. : Sql dba

1077

List the different type of joins?

1067

What is the difference between view and stored procedure?

966

What is java sql package?

1103