What is the difference between count 1 and count (*) in SQL?

Related questions

1. What is the purpose of group by clause?
2. Can distinct be used with group by?
3. Can we use both group by and orderby together in SQL?
4. How do I find duplicates in SQL?
5. Is unique in SQL?
6. What comes first group by or order by?
7. Can we use group by and order by in same query?
8. Which comes first order by or group by?
9. What is the difference between group by and distinct in SQL?
10. What is difference between orderby and group by in SQL?

Tags

1. #number
2. #difference
3. #faster
4. #simple
5. #table
6. #query
7. #counts
8. #whereas
9. #produced
10. #accessing
11. #values
12. #which
13. #count
14. #index
15. #because
16. #database
17. #often