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 I find query history in sql server?
How would we use distinct statement? What is its use?
What is the default sql server instance name?
What types of integrity are enforced by a foreign-key constraint
Why can there be only one clustered index and not more than one?
What are the magic tables in SQL Server 2000?
7 Answers Infogain, Merrill Lynch,
When would you use a before or after trigger?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Explain an automatic checkpoint
how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
Is sql server 2016 free?
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)