select 150 from tab Ans:150 150 150 -- -- 150(2

in a table it has 200 rows the query is select 150 from
tablename.whats the output

Question Posted / qlikstar

Answer Posted / qlikstar

select 150 from tab
Ans:150
150
150
--
--
150(200 times)

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How we can use union transformation?

1026

update strategy transformation in informatica

1039

How to convert multiple rows to single row (multiple columns) in informatica

1342

Design time, run time. If you don't create parameter what will happen

1816

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10656

What are the different types of transformation available in informatica.

1064

draw informatica architecture 8.6 ?

3844

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1247

What is the difference between Active and Passive transformation?

1111

What is expression transformation?

1064

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5721

What you know about transaction control transformation?

962

Can we create multiple integration service on single repository?

1158

What does “tail –f” command do and what is its use as an Informatica admin.

1063

How do you load alternate records into different tables through mapping flow?

1827