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
Can we debug stored procedure?
Can we use delete in merge statement?
What are all the ddl commands?
What is the use of sqldataadapter?
What does varchar include?
What is tuple in sql?
How do I audit the sql sent to the server?
Is postgresql a nosql database?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is the difference between the sql*loader and import utilities? : aql loader
How is a PL/SQL code compiled?
What is procedure in pl sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
what is cursor. write example of it. What are the attributes of cursor.
What is the use of index in sql?