Answer / vikram

select * from emp where rowid >( select count(*)-n from emp)

Answer / nitin

NAME EMP_ID
A 100
B 102
C 103
D 105
E 200
F 201
G 202
H 203
I 204

SELECT * FROM (select * from emp order by emp_id desc)
WHERE rownum <= 5

Answer / sarmistha

select TOP (5) * from emp order by empid desc

Answer / basanti meher

select * FROM (SELECT * FROM TEST ORDER BY ROWNUM DESC ) where rownum <=5 ;

Answer / keshav

Select*from emp
Minus
Select * from emp
Rownum<=(select count (*) -5 from emp);

Answer / newuser

select * from (select * from employee order by rowid desc) t
where rownum<= 5;

Answer / vasanth

HI,

Include equal to (=) in that query:

select *
from temp_search
minus (select *
from temp_search
where rownum <= (select count(*) - n from
temp_search))

Another example:

select xx.*
from (select rownum rr, a.* from temp_search a) xx
where xx.rr > (select count(1) - n from temp_search)

*- n : no of last tranactions

Answer / eshwer

create trigger on emp table with last_transaction with datatype as date or timestamp,

now you have to use dml commands on emp table, when ever u done any modifications on the table these will be inserted in
last_transaction with sysdate with last modification time,

based on time we can find out the last transactions

based on

Answer / 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

Answer / thulasi reddy

select * from emp minus(selecet * from emp where
rownum<(select count(*)_4 from emp))



this will give last records

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

What is embedded sql in db2?

0 Answers  

How do I view tables in mysql?

0 Answers  

What is the difference between in and between in sql?

0 Answers  

What are the qualities of 2nf?

0 Answers  

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

How many types of relationship are there?

0 Answers  

Differentiate pl/sql and sql?

0 Answers  

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

What are the packages in pl sql?

0 Answers  

what is primary key? : Sql dba

0 Answers