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

Explain the difference between a data warehouse and a data mart?

1056


How do you update the records with or without using update strategy?

1112


In informatics server which files are created during the session rums?

1113


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1903


what is the size of u r source(like file or table)?

2271


generate date / time dimension in informatica

1125


What is the advantage of informatica?

1069


How do you handle two sessions in Informatica

1158


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1579


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2119


Define filter transformation?

1095


draw informatica architecture 8.6 ?

3871


What is the difference between stop and abort in informatica

1095


What is the difference between Active and Passive transformation?

1150


Suppose we do not group by on any ports of the aggregator what will be the output?

1041