Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sachin rathi
Count(column name or exp) returns the no. of records for a
specific/particular column of table excluding null values
whereas Count(*) returns all the rows/records in the table
including duplicated and null values
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is sql injection? How to protect against sql injection attack?
Do you know the capabilities of cursors?
How to enforce security in sql server? : sql server security
What are the types of resultset?
How many clustered indexes there can be on table ?
What is "scheduled jobs" or "scheduled tasks"?
Explain a differential backup?
What is exclusive locks?
What is difference between group by and having?
Explain about integration services of Microsoft SQL server?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is a sql join?
What are the different subsets of sql?
What is triggers and its types?
