What is the datatype returned by count(*)
Answers were Sorted based on User's Feedback
Answer / gunjan sapra
The datatype returned by count(*) is INTEGER type.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / sathishrpillai
It returns Integer data type.
since count function return the total count of a particular
fields.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / vikky
Count(*) returns number of rows(counts) available in table.
It returns Int datatype
| Is This Answer Correct ? | 8 Yes | 1 No |
What is the osql utility?
What is a trace frag?
what happens on checkpoint? : Sql server database administration
Why functions are used in sql server?
What is query and its types?
How to write a query with a right outer join in ms sql server?
What is explicit cursors?
What is change data capture (cdc) in sql server 2008?
Which data type can be used only on OUTPUT parameters of the stored proceduer?
What is ms sql server index?
How to create a user name in a database?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)