How do you retrieve the last N records from a table?
- 10 Answers
- 15832 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What's the difference between inner join and left join?
What is form and report?
What will you get by the cursor attribute sql%rowcount?
Is sql a oracle?
How to raise user-defined exception with custom sqlerrm ?
Can we enter data in a table in design view?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is ttitle and btitle?
Is sql microsoft?
what is the difference between a local and a global temporary table? : Sql dba
What version is sql?
What is field delimiter?
How to execute a stored procedure?
Is subquery faster than join?
What is difference between sql and excel?
