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
What is difference between cursor and trigger?
What do you mean by query optimization?
Is pl sql a programming language?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What are the popular database management systems in the it industry?
How does cross join work?
How can we link a sql database to an existing android app?
What are the methods of filing?
What is the difference between joins?
What is pls integer?
The select into statement is most often used to create backup copies of tables or for archiving records?
What is the non-clustered index in sql?
What has stored procedures in sql?
Is mariadb nosql?
What is the starting oracle error number? What is meant by forward declaration in functions?