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
What do you understand by the denormalisation?
Define full outer join?
What causes index fragmentation?
Explain the truncate command? : SQL Server Architecture
How to use copy and concatenate commands in SQL?
If we delete pack Spec what will be the status of pack Body ?
What is global temp table?
Explain the Ways to improve the performance of a sql azure database?
What is a data collection table?
Where can you add custom error messages to sql server?
When cursors are useful?
what is a schema in sql server 2005? : Sql server database administration
why would you call update statistics? : Sql server database administration
Explain the different types of joins?
User wants only to display only pdf as export option in report manager. How to achieve this?