How do you retrieve the last N records from a table?
Answer Posted / swastik
select
* from
(
select e1.*
from emp e1
order by rownum desc
)
where rownum <= &n
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I kill a query in postgresql?
Can we insert data in view?
What are the types of triggers in sql?
what is bcp? When is it used?
What is set transaction?
What is form and report?
What is the left table in sql?
What are the different ddl commands in sql?
Describe sql comments?
Why we use cross join?
Write the alter statement to enable all the triggers on the t.students table.
Why do you partition data?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
In pl/sql, what is bulk binding, and when/how would it help performance?
What is offset in sql query?