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 are page splits? : SQL Server Architecture
How to convert numeric expression data types by assignment operations?
How you can change a cross join into an inner join?
If we use where clause in the left outer join then how the query would behave/act?
syntex of insert
How to Install SQL SERVER 2005 remotely?
What is the native system stored procedure to execute a command against all databases?
What the different topologies in which replication can be configured?
After the SQL installation what are the jobs will you configure?
1 Answers G7 CR Technologies, IBM, Satyam,
What are the different types of replication? How are they used?
Explain the different types of joins?
Which command using Query Analyzer will give you the version of SQL server and operating system?
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)