adspace


  1. Categories >> Software >> Databases >> DB Development
  2. Suggest New Category

Write the fastest query to find out how many rows exist in a table?

Question Posted / Vivek Kishor

Answer Posted / Vivek Kishor

The fastest way to get the number of rows in a table is using the COUNT(*) function. However, if you want an exact count without considering NULL values, use COUNT(column_name) where column_name refers to a non-nullable column.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2106