Browse by Tags

All Tags » count   (RSS)
Different ways to count rows from a table
02 November 07 08:25 AM | Madhivanan | 2 Comments   
The most reliable and suggested method is to use count(*) 1 Select count(*) from table_name But other than that you can also use one of the followings 2 select sum(1) from table_name 3 select count(1) from table_name 4 select rows from sysindexes where Read More...
Filed under: , ,