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 / raghuram

the question is how do find number of rows in a table?

select count(*) from table_name

by using this we will get exact number of rows in a table.

Is This Answer Correct ?    10 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What command is used to delete a table from the database in the sql server and how?

1098


What are the different types of sql server replication? : sql server replication

1249


Tell me what are the advantages of using stored procedures?

998


Explain the use of containers in ssis and also their types?

960


How do we know if any query is retrieving a large amount of data or very little data?

961


What is meant by datasource?

915


Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

945


What is the difference between locking and multi-versioning?

981


How do I know if localdb is running?

941


Do you know what is user defined datatypes and when you should go for them?

959


What is a data source file?

960


It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1024


What are the disadvantages of using querystrings to send data from one page to another?

985


How can we improve performance by using SQL Server profiler?

1047


Why Master database is required?

1122