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 null in pl/sql?
What is snowflake sql?
How do you write a subquery?
What is the starting oracle error number?
What is the difference between pl and sql?
How do you select unique values in sql?
what are string data types? : Sql dba
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is the plv (pl/vision) package offers?
Does sql profiler affect performance?
explain access control lists. : Sql dba
How can get second highest salary in sql?
What is the maximum size of sqlite database?
How do you declare a user-defined exception?
What is scope and visibility in PL/SQL?