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
- 23558 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 happens if you no create privilege in a database? : Sql dba
Which function is used to return remainder in a division operator in sql?
Is left join faster than join?
What do we need to check in database testing?
How do you remove duplicates without using distinct in sql?
How to run sql*plus commands in sql developer?
How to select random rows from a table?
What are the different ways to optimize a sql query?
What are different functions in sql?
How many types of privileges are available in sql?
Write the command to remove all players named sachin from the players table.
What is procedure function?
What are the most important ddl statements in sql?
What is trigger in pl sql?
Is it possible to update views?
