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
11099 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 you understand by term role-playing dimension?

1119

What is session task and command task?

1398

What differs when we choose the sorted input for aggregator transformation?

1076

How can we store previous session logs?

1140

Explain lookup transformation in informatica

1131

What is difference between a gateway node and worker node?

1203

Tell me about MD5 functions in informatica

983

how many types of dimensions are available in informatica?

1181

How to open an older version of an object in the workspace?

1265

How to configure mapping in informatica?

1225

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2246

Explain in detail scd type 2 through mapping.

1092

What is Session and Batches?

1155

What are roles and groups and benefits of using them?

1104

What is rank transformation?

1037