adspace


What does count (*) do in sql?

Answer Posted / Raisuddin Khan

In SQL, 'COUNT(*)' is a SQL aggregate function that returns the number of rows within a result set. Unlike COUNT(), COUNT(*) counts all rows, regardless of whether they are NULL or not.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does group by remove duplicates?

1122


What is the best sql course?

1064


what is sql server agent? : Sql dba

1191


how to escape special characters in sql statements? : Sql dba

1125


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2102


what is dbms? : Sql dba

1072


what are the advantages of sql ? : Sql dba

1154


what are all the common sql function? : Sql dba

1143


Can we use distinct and group by together?

1148


How do I remove duplicates in two columns?

1204


Is primary key clustered index?

1028


What is the current version of sql?

1106


Do we need to rebuild index after truncate?

1156


define sql insert statement ? : Sql dba

1110


what is schema? : Sql dba

1165