Write a query to get last 10 records from the table.
Answer Posted / l meher
select * from emp minus select * from emp where rownum<=
(select count(*)-10 from emp);
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
what is the difference between a having clause and a where clause? : Sql dba
How to run sql statements with oracle sql developer?
What is data definition language?
What are the two types of exceptions in pl/sql?
What is the difference between sum and count in sql?
What is delimiter in pl sql?
What is the reports view in oracle sql developer?
What is the difference between jpql and sql?
How does one load ebcdic data? : aql loader
What is pessimistic concurrency control? : Transact sql
Is delete faster than truncate?
What trigger means?
How to change sql*plus system settings?
what are the advantages of using stored procedures? : Sql dba
What are conditional predicates?