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
- 9329 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
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Define Business Edition in SQL Azure?
Explain how does the report manager work in ssrs?
What is hot add cpu in sql server 2008?
What is a field in a table?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is efficiency data?
What’s the use of custom fields in report?
What is identity?
Explain about system stored procedure?
How to use “drop” keyword in sql server and give an example?
Can group functions be mixed with non-group selection fields in ms sql server?
What is an expensive query?
What are sql servers used for?
what purpose does the model database serve? : Sql server database administration
