How do you retrieve the last N records from a table?
Answer Posted / ajit
SELECT RN, Ename
FROM ( SELECT Rownum RN, Ename
FROM Emp )
WHERE RN = &Grecno;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is online transaction processing (oltp)? : Sql dba
What is field delimiter?
how do you control the max size of a heap table? : Sql dba
give the syntax of grant and revoke commands? : Sql dba
Can we join same table in sql?
what is a field in a database ? : Sql dba
what is table? : Sql dba
Does pdo prevent sql injection?
What is meaning of <> in sql?
Why plvtab is considered as the easiest way to access the pl/sql table?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
how to rename an existing table in mysql? : Sql dba
Explain the difference between triggers and constraints?
What is sql*plus?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql