Count(*) returns number of rows(counts) available in table. It returns In

What is the datatype returned by count(*)

Question Posted / vikky

Answer Posted / vikky

Count(*) returns number of rows(counts) available in table.
It returns Int datatype

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what stored procedure would you use to view lock information? : Sql server administration

586

Tell me what is the difference between locking and multi-versioning?

579

How secure is sql server database?

525

what protocol both networks use? : Sql server database administration

542

How to delete all rows with truncate table statement in ms sql server?

494

What is Federation Root Database?

Do you know what is lock escalation?

582

What are the types of ssrs?

108

How to execute function in stored procedure sql server?

545

Is truncate a dml command?

503

What do you do in data exploration

568

Explain the stored procedure?

642

Mention the 3 ways to get a count of the number of records in a table.

555

What are the advantages of mirroring?

574

Do you know what are the steps to process a single select statement?

537