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 is a covering index?
How to genrate automaticlly empid like gt001
Is it possible in sql table to have more than one foreign key?
How can you fetch alternate records from a table?
What do you understand by triggers?
Tell me the phases a transaction has to undergo?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Explain having clause and where clause?
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.
Explain about local stored procedure?
How to delete the duplicate rows from a table in SQL Server ??
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
11 Answers World Tech, Yardi Software,