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

As union transformation gives UNION ALL output, how you will get the UNION output?

1106


What is the different lookup cache(s)?

1086


According to his methodology what all you need before you build a datawarehouse

1757


Explain Dataware house architecture .how data flow from intial to end?

2582


what is unit testing?tell me proceedure

2221


What are the uses of etl tools?

1128


What are the main features of Oracle 8i with context to datawarehouse?

2112


What does reusable transformation mean?

1132


What are the new features of informatica 9.x developer?

970


Where can we find the throughput option in informatica?

1063


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2160


Define enterprise data warehousing?

1204


Explain lookup transformation in informatica

1073


How to update source definition?

1087


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1674