Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Is it possible to revert a global repository to local one and why?

1023


list out all the transformations which use cache?

1112


can we override a native sql query within informatica? Where do we do it? How do we do it?

1013


How do you load unique records into one target table and duplicate records into a different target table?

1163


What is exclusive and normal mode for repository services?

1062


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1874


Can informatica load heterogeneous targets from heterogeneous sources?

1118


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1994


What is enterprise data warehousing?

987


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 ?

2121


Describe an informatica powercenter?

1035


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1024


Could you explain what is enterprise data warehouse?

1047


What is joiner transformation in informatica?

993


What is the need of an ETL tool?

1027