What is the datatype returned by count(*)

Answer Posted / haribabu

it returns how meny columns in the data table (or)
how meny records in the table

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can group by be used without aggregate functions?

693


What are the differences between having and where clause.

719


what is a default tcp/ip socket assigned for sql server? : Sql server database administration

775


While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

760


What are key, name and value columns of an attribute? : sql server analysis services, ssas

775


What is statement level trigger?

769


Explain different types of locks in sql server.

781


How to compare the top two records using sql?

976


How do you trace the traffic hitting a sql server?

820


What are the disadvantages of using the stored procedures?

711


How can a user-defined datatype be created?

732


While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

796


List all types of constraints in sql server?

693


How much memory that we are using in Logshipping Concept?

1552


What is RMS migrations?

1899