Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between the following two sql
statements
select count(*) from <tablename>
select count(col_name) from <tablename>
- 5 Answers
- 9556 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / sandeep
select count(*) from <tablename>
- return number of records from table
select count(col_name) from <tablename>
- return number of records where col_name is NOT NULL
- Null value is eliminated by an aggregate or other SET
operation.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain the dirty pages?
Do you have any idea about the tcl commands?
What is temporal table?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What is a sql join?
What is the advantage of sql server?
Explain few examples of RDBMS?
What is an indice?
Find first and last day of current month in sql server
How to use wildcard characters in like operations in ms sql server?
Which table keeps the locking information?
Can we return Data from 4(more than 1) tables in stored procedure?
What is stored in the mssqlsystemresource database? : sql server database administration
What is the latest version of microsoft sql server?
How to find out the list schema name and table name for the database?
