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 will you go about resolving deadlocks?
Write an SQL query to obtain the 2nd highest salary.
0 Answers Akamai Technologies,
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Explain the difference between control flow and data flow?
What are the methods used to protect against sql injection attack?
How many databases instances are there in sql server 2000?
How can you append an identity column to a temporary table?
Explain primary key?
Get Current System Date Time
Write the Syntax for Cursors.
2 Answers CarrizalSoft Technologies, HP,
What is the purpose of object explorer and its features? : sql server management studio
What is a unique key constraint?
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)