What is the difference between the following two sql
statements
select count(*) from <tablename>
select count(col_name) from <tablename>
Answer Posted / karthik
both will be display same record count.
Is This Answer Correct ? | 2 Yes | 12 No |
Post New Answer View All Answers
How can we rewrite sub-queries into simple select statements or with joins?
What is command parameter in ssrs?
What is the difference between NOROW and LOCKROW?
Explain what are sparse columns?
Explain the usage of floor function in sql server.
What is use of attributehierarchyenabled? : sql server analysis services, ssas
What is the stuff and how does it differ from the replace function?
How to change server name in sql server?
What is a mutating table error and how can you get around it?
What is the cartesian product of the table?
what is a join? : Sql server database administration
What is the full form of dql?
How to manipulate data from one table to another table ?
List the different index configurations possible for a table?
Explain transaction server consistency?