What is the datatype returned by count(*)
- 22 Answers
- 32299 Views
- 247Customer, Asian CERC, I also Faced
- E-Mail Answers
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 |
whats the maximum size of view state??
What security features are available for stored procedure?
Why use update_statistics command in sql server?
what are the new features introduced in sql server 2000? : Sql server database administration
what is diffence between replicaion and logshipping?
write a query to remove duplicate records without using primary key column?
How can you check the version of sql server?
What is the difference between dbcc indexdefrag and dbcc reindex?
What are partitioned views and distributed partitioned views?
How can we get count of the number of records in a table?
What are the properties of the transaction?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
