What is the difference between the following two sql
statements
select count(*) from <tablename>
select count(col_name) from <tablename>
Answer Posted / kushi
for the First Qry,result is "No.of records"
for the second Qry,result is "No.of records for particular
columnname"
Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What do you mean by subquery?
What is user-defined inline table-valued function?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
How to create a Master database in SQL server ?
What are the different types of collation sensitivity?
What are the different types of Indexes available in SQL Server?
What is meant by indexing files?
How to disconnect from a sql server using mssql_close()?
What is a partition key?
Explain time data type in sal server 2008?
Explain the difference between functions and stored procedures in sql server?
What is openxml in sql server?
Difference between DELETE and TRUNCATE?
Why Master database is required?
What is report snapshot?