What is the difference between the following two sql
statements
select count(*) from <tablename>
select count(col_name) from <tablename>
- 5 Answers
- 7967 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / karthik
both will be display same record count.
| Is This Answer Correct ? | 2 Yes | 12 No |
Post New Answer View All Answers
what is the different types of backups available in sql server? : Sql server database administration
what are different types of raid configurations? : Sql server database administration
how you can deploy an ssrs report?
What is the cpu pressure?
Differentiate between truncate vs delete in mssql?
What is nested transaction?
How to grant a permission in ms sql server using "grant execute" statements?
When I run the sql server 2000 setup, it just hangs. What do I do?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How to use old values to define new values in update statements in ms sql server?
How do I manually uninstall an instance of sql server 2016?
What causes index fragmentation?
What are the advantages of using stored procedures in sql server?
What is the rdl file?
How data can be copied from one table to another table?
