What is difference between count (*) and count 1?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What are the types of model in sql server and explain

2 Answers   TCS,


How to connect sql server management studio express to sql server 2005 express?

0 Answers  


optimization techinques

0 Answers   Wipro,


What are the advantages of the mirroring?

0 Answers  


How do you know if sql server is running on your local system?

0 Answers  






how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  


Can we write ddl in trigger?

0 Answers  


Can you please differentiate between a primary key and a unique key?

0 Answers  


Is it true, that there is no difference between a rule and a check constraint?

0 Answers  


Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 Answers  


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

0 Answers  


How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,


Categories