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 |
What command do we use to rename a db, a table and a column?
Why do we need different type of parameter?
How to create a dml trigger using create trigger statements?
What are the joins in sql server? : sql server database administration
Explain about extended stored procedure?
Explain what is the difference between union and union all?
What is the difference between clustered and non-clustered indexes in ms sql server?
Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?
WHAT OPERATOR PERFORMS PATTERN MATCHING?
2 Answers CarrizalSoft Technologies, CTS,
Explain different types of index?
What action plan is preferred if sql server is not responding?
How do I clean up sql server transaction log?