Interested to Buy Any Domain ? << Click Here >> for more details...
I want to know last five transactions or records from emp
table, from now?
- 11 Answers
- 21306 Views
- Wells Fargo, I also Faced
- E-Mail Answers
Answer Posted / sidhu
For ex: emp table, we want last five transaction in emp
select * from emp
minus
select * from emp where rownum <= (select count(*)-&n from emp);
this will work and give the value 5 it will return last five transacitons.
hope this helpful
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why do we need cursors in pl sql?
What is latest version of sql?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is embedded sql in db2?
What is sql architecture?
What is nvarchar in sql?
What is indexing oracle sql?
What is the difference between microsoft access and sql server?
What is rtm stands for?
what is self-join? : Sql dba
What is a system versioned table?
What is cursor in pl sql with examples?
How many types of indexes are there in sql?
What is group by in sql?
Write the command to remove all players named sachin from the players table.
