Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between the following two sql
statements
select count(*) from <tablename>
select count(col_name) from <tablename>
- 5 Answers
- 9517 Views
- 247Customer, I also Faced
- E-Mail Answers
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 is the difference between Normalization and De-normalization?
How can we call UDF(User Define Function) using C# code in ASP.net ?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What are information schema views?
How are the unique and primary key constraints different?
What is the process of indexing?
What are a scheduled jobs?
Can a trigger be created on a view?
What is the difference between dataadapter and datareader?
Is null vs coalesce?
Explain what is analysis service repository?
What is cursors? And what are the different types of cursor?
What are a database and a data warehouse?
What do you understand by the analysis services in sql server?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
