select * from (select rownum as num,a.* from A a) where num=(select count(*

i have oracle table A and target B. i don't know how many
records. i want get get last record in table A as first record
in target table B. write a sql query?

Question Posted / upendra

7 Answers
10613 Views
IBM, TCS, I also Faced
E-Mail Answers

Answer Posted / upendra

select * from (select rownum as num,a.* from A a) where num=(select count(*) from A);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is main use of mapplet?

1084

How to update or delete the rows in a target, which do not have key fields?

1131

my source is junk data how will u remove that junk data by using unix please any one replay me

3660

What is target load order?

1196

What is enterprise data warehousing?

995

How can a transformation be made reusable?

1089

What is the difference between a repository server and a powerhouse?

1428

On which transformations you created partitions in your project?

1269

Which development components of informatica have the highest usage?

996

What does role playing dimension mean?

1006

How to elaborate tracing level?

1123

What is a router transformation?

1060

What is workflow? What are the components of workflow manager?

1133

explain abt ur project architecture?

2129

draw informatica architecture 8.6 ?

3831