how to retrieve last tree records from table?
select *from emp where rownum > (select count(*)-3 from
emp);
i am using this query to get last three records from table
but its not giving any output, so please tell me what is the
error in this query.
- 16 Answers
- 19652 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramareddy
u don't use minum operator to count(*) in subquerry
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Which is faster joins or subqueries?
what is unique key constraint? : Sql dba
how can we optimize or increase the speed of a mysql select query? : Sql dba
Why query optimization is needed?
Which certification is best for sql?
What is cartesian join in sql?
Is it important to partition hard disk?
Explain the difference between drop and truncate commands in sql?
What is the default isolation level in sql server? : Transact sql
What is pragma in pl sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Do we need to create index on primary key?
What are the possible values that can be stored in a boolean data field?
How do you declare a user-defined exception?
What is a unique constraint?
