Browse by Tags

All Tags » count (RSS)

Different ways to count rows from a table

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...
Posted by Madhivanan | 6 comment(s)
Filed under: , ,