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
- 21379 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 analyzer?
Can dml statements be used in pl/sql?
What is parameter substitution in sql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
How to select all records from the table?
What is a nested table in word?
what is timestamp in mysql? : Sql dba
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Why do we need sharding?
What is view explain with example?
Explain the advantages and disadvantages of stored procedure?
What is a recursive join sql?
What is materialized view. What are different methods of refresh?
Does pl sql work in mysql?
What is sqlerrd?
