Interested to Buy Any Domain ? << Click Here >> for more details...
What is the datatype returned by count(*)
- 22 Answers
- 38932 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 |
Explain stored procedure?
CREATE a table from another table
How to move database physical files in ms sql server?
What are the types of resultset?
how you can list all the tables in a database?
How to use “drop” keyword in sql server and give an example?
What is a dbms wizard?
Which autogrowth database setting is good?
What do you need to connect php to sql server?
What is a Lock and let me know Different types of locks?
hi i gone though satyam interview. what is Acid Properties?
What stored by the tempdb ? : sql server database administration
-
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)
