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
- 21344 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
Write a sql query to convert all character to uppercase after hypen.
how many sql dml commands are supported by 'mysql'? : Sql dba
How are functions and procedures called in PL/SQL?
Is sql the best database?
How many sql core licenses do I need?
What is sqlca in db2?
How much does a sql dba make? : SQL DBA
What is a delimiter in sas?
Why cross join is used?
what is the difference between sql and t-sql? : Transact sql
Does sap use sql?
How do I tune a sql query?
Explain the order of sql statement execution?
what is the syntax for using sql_variant_property? : Transact sql
What is the purpose of normalization?
