Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 23779 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
What is file based approach?
What is denormalization in a database?
What is the use of desc in sql?
How do I kill a query in postgresql?
How to pronounce postgresql?
What is the purpose of primary key?
What is a sql driver?
What are inner outer left and right joins in sql?
What are the triggers associated with image items?
What are all the different normalization?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How do I run sql profiler?
Explain some predefined exceptions.
what is transaction? : Sql dba
How to read/write files from pl/sql?
