How do you retrieve the last N records from a table?
Answer Posted / rajat
SELECT * FROM EMP A
WHERE ROWID NOT IN
(SELECT ROWID FROM RAJ WHERE ROWNUM<=(SELECT COUNT(1) FROM RAJ )-10);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can the performance of a trigger be improved?
how to present a past time in hours, minutes and seconds? : Sql dba
Is primary key an index?
How do I add a database to sql?
Where not exists in sql?
What is dbo in sql?
What is Materialized View? In What Scenario we Use Materialized View?
Is full outer join same as cross join?
What is pl sql package?
Does truncate release storage space?
What is pl sql record in oracle?
What can sql server reporting services do?
What are three advantages to using sql?
What is trigger in pl sql?
Which function is used to return remainder in a division operator in sql?