Interested to Buy Any Domain ? << Click Here >> for more details...
What is the datatype returned by count(*)
- 22 Answers
- 39617 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 |
Do you know query execution plan?
what is statistics
What are the difference between primary keys and foreign keys?
Tell me about normalization in DBMS.
Does union all remove duplicates?
Explain the different types of joins?
What authentication modes does sql server support?
What is 1nf 2nf and 3nf?
What are the character string functions supported by sql server 2005?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
Delete duplicate records from the table?(Table must have unique id)
7 Answers TCS, Thomson Reuters,
How does clustered and non clustered index work?
-
Oracle (3253) - 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)
