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

Write the SQL query to drop, truncate and delete table.

724

Tell me what are the essential components of sql server service broker?

684

What is the current limitation of the size of SQL Azure DB?

120

Can a table be created inside a trigger?

723

Explain about remote stored procedure?

772

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

846

What is exporting utility?

707

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

744

What is co-related sub query?

733

Define views.

753

How to write a query with an inner join in ms sql server?

749

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

714

What is always encrypted?

689

What purpose does the model database server?

851

How do you start single user mode in clustered installations?

704