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
- 23677 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 sql and its types?
How to load data with sql*loader?
Are stored procedures faster than dynamic sql?
Which data dictionary views have the information on the triggers that are available in the database?
Explain unique key in sql.
Is id a reserved word in sql?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What are local and global variables and their differences?
How to get unique records from a table?
Why is nosql good?
what is the use of set statement in tsql? : Transact sql
How to disable a trigger name update_salary?
What is secondary key?
What is file based approach?
What is the difference between syntax error and runtime error?
