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
10830 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 the session task and command task?

1049

how many types of dimensions are available in informatica?

1087

Partition, what happens if the specified key range is shorter and longer

2487

How does a sorter cache works?

1062

What are the main features of Oracle 8i with context to datawarehouse?

2109

What is event and what are the tasks related to it?

1116

Mention some types of transformation?

1040

What is lookup transformation?

1037

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2114

Explain about Informatica server process that how it works relates to mapping variables?

1066

How do you use reject loader.

2600

Different circumstance which drives informatica server to expel records?

971

Explain the types of lookup transformation?

1041

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1072

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1078