What is the difference between count and distinct count?


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

Post New Answer

More SQL Server Interview Questions

What is filestream?

0 Answers  


What are data resources?

0 Answers  


How to read data in a table with "select" statements?

0 Answers  


1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,


what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,






Can you explain the disadvantages/limitation of the cursor?

0 Answers  


What are date and time data types in ms sql server?

0 Answers  


How many types of built in functions are there in sql server 2012?

0 Answers  


can you any body tell me which service pack is installed in the sql server?

3 Answers  


What is ms sql server index?

0 Answers  


What is the difference between for trigger and after trigger?

0 Answers  


In which format does an image save in SQL Server database ?

0 Answers   MCN Solutions,


Categories