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 is difference between index and primary key?
do you know how to configure db2 side of the application? : Sql server database administration
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
How will you hide an attribute? : sql server analysis services, ssas
How self join is different from outer join?
How to apply filtering criteria at group level with the having clause in ms sql server?
Define Wed Edition in SQL Azure?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Explain what is raid and what are different types of raid levels?
How to create an index on an existing table in ms sql server?
What are the steps you will take to improve the performance of a poor performing query?
How to generate create view script on an existing view?
Can we deploy SSRS reports on our personal website?
Explain user defined views?
How to return the date part only from a sql server datetime datatype?