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

Answer Posted / babu

Hi all,

it is very simple.

if you give any number in the select list it will displays the
that number(how many records table havie that number of times)

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

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is expression transformation?

629


Write the unconnected lookup syntax?

653


Explain the etl program with few examples.

543


What is an unconnected transformation?

659


Does an informatica transformation support only aggregate expressions?

604






Quickly characterize reusable change?

687


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1864


What is the difference between informatica 7.0 and 8.0?

563


What does role playing dimension mean?

621


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

801


where to store informatica rejected data? How to extract the informatica rejected data?

597


What are the components of the workflow manager?

635


what is the -ve test case in your project.

1846


What is an Integration service in Informatica?

699


What are the different components of powercenter?

578