How do you retrieve the last N records from a table?
- 10 Answers
- 16761 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 is scope and visibility in PL/SQL?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Explain how to use transactions efficiently : transact sql
What is the difference between stored procedure and view?
how many tables will create when we create table, what are they? : Sql dba
Why do we use view in sql?
What does pl sql stand for?
Explain the order of sql statement execution?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
what is a control file ? : Sql dba
What does seeding a database mean?
What are the basic techniques of indexing?
What is type and rowtype in pl sql?
Is time a data type in sql?
How will you distinguish a global variable with a local variable in pl/sql?
