Interested to Buy Any Domain ? << Click Here >> for more details...
What is the datatype returned by count(*)
- 22 Answers
- 39137 Views
- 247Customer, Asian CERC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harsh
SELECT COUNT(*) as "Number of employees"
FROM employees
WHERE salary > 55000;
It would return the following result set:
Number of employees
5
HENCE IT RETURNS 'INT' TYPE.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sanjeev kumar
It will return Int or Bigint depend on the size of the row.
(But both are same)
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / thirumal
count(*) returns the total number of not null values in
given column
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / lakshmi narayanan r
It will return INT. Proof is here...
SELECT COUNT(*) AS Total INTO tmpArchiveStoreMaster1 FROM
ArchiveStoreMaster asm
GO
sp_help tmpArchiveStoreMaster1
Name
Owner
Type
Created_datetime
--------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
------------------------------- -----------------------
tmpArchiveStoreMaster1
dbo
user table 2010-07-06
15:43:05.310
Column_name
Type
Computed Length
Prec Scale Nullable
TrimTrailingBlanks FixedLenNullInSource
Collation
--------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------
----------------------------------- ----------- ----- -----
-----------------------------------
-----------------------------------
-----------------------------------
--------------------------------------------------------------------------------------------------------------------------------
Total
int
no 4
10 0 yes (n/a)
(n/a)
NULL
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / haribabu
it returns how meny columns in the data table (or)
how meny records in the table
| Is This Answer Correct ? | 1 Yes | 4 No |
Answer / server.getlasterror().message
Server.GetLastError().Message
| Is This Answer Correct ? | 2 Yes | 5 No |
Which are new data types introduced in sql server 2008?
What is transaction server distributed transaction?
what is curser.
What are the advantages of user-defined functions over stored procedures in sql server?
How to rebuild indexes with alter index ... Rebuild?
What are the advantages of sql stored procedure?
Which stored procedure will you be running to add a linked server?
How do I delete a sql server database?
Do you know what are acid properties?
What is a deadlock and what is a live lock?
Define full outer join in sql server joins?
How column data types are determined in a view?
-
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)
