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

How do you find the number of rows in a table?

Answer Posted / anand

select count(*) from table_name will hold good if there isn't any WHERE clause in it as it is a AGGREGATE Function.. (just additional information)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Determine when an index is appropriate?

1024


What are data driven subscriptions?

108


Define tool Manage Statistics in SQL Server 2000 query ?

1033


What is a benefit of using an after insert trigger over using a before insert trigger?

936


What are a scheduled jobs?

913


What is a data source or ds? : sql server analysis services, ssas

960


What is a database table?

933


How to count rows with the count(*) function in ms sql server?

960


How you can get a list of all the table constraints in a database?

918


what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1000


What is the size of transaction log file?

875


Define left outer join?

934


How to drop existing views from a database in ms sql server?

1050


Explain the flow of creating a cube? : sql server analysis services, ssas

1013


What is the minimum recommended amount of ram for sql server 2012 enterprise?

896