Difference between Count(*), Count(1), Count(colname) | SQL Interview Question | IQBees
Hello everyone,
Today's session we are going to discuss the differences between the count(*), the count(1) and the count(colname) queries in S.Q.L.. this is also one of the questions asked commonly in interviews
count(*) or count(1) statement will count all the records in the table but count on column name would count all the non null records on that column.
I hope that this will help you in answering the interview questions. if you found the video useful, then please like comment and share this video and also please do not forget to subscribe to a youtube channel because we will be posting many more videos soon.
Thanks a lot for watching.
IQBees
Difference between Count(*), Count(1), Count(colname) | SQL Interview Question | IQBees
#sqlinterviewquestions
#sqlqueries
#sql
#sqlserver
#sqlforbeginners
#sqltutorials
#sqltutorialforbeginners
Order Of Execution in SQL Query | IQBees @crackconcepts @LearnCodingOfficial @CodeEra2020
Tricky SQL questions on Strings | Like Operator | Substring Function | CHARINDEX | IQBees