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 |
How do you trace the traffic hitting a sql server?
What Is The Difference Between Primary Key & Super Key
Is sql server implemented as a service or an application? : Sql server database administration
Explain the microsoft sql server delete command? : SQL Server Architecture
What is transaction server isolation?
diffrence between Cluster Index and non Cluster Index
What number sorts of privileges are accessible in sql?
What objects does the fn_my_permissions function reports on? : sql server security
How you can minimize the deadlock situation?
How to test subquery results with the exists operator?
What is attribute relationships, why we need it? : sql server analysis services, ssas
How to transfer Logins from SQL Server 2000 to 2005
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)