How do you retrieve the last N records from a table?
Answer Posted / nani
select * from emp a where &N > (select count(*) from emp b
where b.rowid > a.rowid)
N = No.of rows.
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Why do we use set serveroutput on?
What is sql profiling in oracle?
What does pragma mean?
Is there a way to automate sql execution from the command-line, batch job or shell script?
Does truncate free space?
Why is stored procedure faster than query?
What are the types of queries in sql?
What is nvl?
Write a sql query to convert all character to uppercase after hypen.
What is record data type?
What is cursor in pl sql?
What is the difference between the sql*loader and import utilities? : aql loader
What is sql and db2?
how do you know if your mysql server is alive? : Sql dba
Where can I learn sql for free?