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
11072 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 do think which one is the better joiner or look up?

1240

What is complex mapping?

1168

How to improve the performance of a session using sorter transformation?

1186

Explain the different kinds of facts.

1020

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1149

What is the sql query overwrite in source qualifier in informatica

1137

design of staging area?

2075

What is informatica etl tool?

1052

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2248

Please let me know how to make Data masking in informatica..

1770

What is the session task and command task?

1110

What are the databases that informatica can connect to windows?

1095

What is fact table? Explain the different kinds of facts.

1121

How we can use union transformation?

1096

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1135