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...

select count(1) from emp? what is the o/p?

Answer Posted / munni

count(1) will give the count of the numbr of records in the
table. count(1) is faster than count(*) since the count is
not based on all the fields.

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the pipeline partition with real time example?

1122


tell me about your project functionality

2329


What is deployment group?

1183


what is informatica metadata?

1014


What is the maplet?

1090


what is $$$$?

2130


What does refresh system mean, and what are its distinctive choice?

1144


What are junk dimensions?

1057


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 ?

2164


What is the difference between informatics 7x and 8x and what is latest version?

1067


Define the various join types of joiner transformation?

979


When do you use sql override in a lookup transformation?

1077


Tell me about Propagate functions in informatica

911


How to join three sources using joiner? Explain though mapping flow.

1128


What are the different types of transformation available in informatica.

1082