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
- 24184 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 procedures and functions?
Explain clause in sql?
explain the difference between bool, tinyint and bit. : Sql dba
what happens if null values are involved in expressions? : Sql dba
What is synonyms?
how to see the create table statement of an existing table? : Sql dba
What is set transaction?
Difference between truncate, delete and drop commands?
Which table is left in left join?
What is a clob in sql?
What does a pl/sql package consist of?
What is the life of an sql statement?
What is linq to sql?
what is data control language? : Sql dba
how can you see all indexes defined for a table? : Sql dba
