Difference between COUNT(1) , COUNT(*), COUNT(COLUMN) and COUNT(ANYTHING)

Опубликовано: 30 Сентябрь 2024
на канале: Coding Glitz

7,846

259

In this video we have discussed difference between COUNT(1) , COUNT(*) and COUNT(COLUMN) in a very simplified way.

Please like & share the video.

Subscribe the Channel to keep watching interesting videos helpful for your career growth:

   / @codingglitz

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

Checkout different playlists:

PLSQL Tutorial :    • PLSQL Tutorial || PL SQL tutorial for...
Learn DBMS & SQL :    • SQL Tutorial for Beginners || SQL Pla...
SQL Interview Questions and answers:    • sql interview questions and answers i...
Java Interview Questions and Answers :    • JAVA Programs for interview
IT Career guidance:    • Career Guidance
Interview Tips :    • Interview Tips
IT Essentials and Tricks :    • IT Essentials and Tricks

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

Checkout Important videos :

Top 30 SQL Queries Interview Questions and Answers :    • SQL Queries Interview Questions and a...
Top 50 SQL Concepts Interview Questions and Answers :    • SQL Interview Questions And Answers
Employee earning maximum salary in each department query :    • SQL Query to find Employee with maxim...
How to delete duplicate rows from any table (2 different solutions):    • SQL query to delete duplicate rows in...
How to find Nth highest salary (3 different solutions):    • SQL query to find Nth Highest salary ...
Tricky SQL Queries Part1 :    • SQL Tricky and Important Interview Qu...
Basics of Database :    • What is DBMS?  Learn Basics of DBMS |...
SQL OPERATORS :    • Operators in SQL  || SQL Tutorial for...
AGGREGATE FUNCTION:    • Aggregate function  || SQL Tutorial f...
GROUP BY :    • GROUP BY  & HAVING || SQL Tutorial fo...
Solve any Date related query :    • How to Solve any SQL Query related to...
How to use Substring :    • Substrings in SQL  | Learn SQL | SQL ...

How to practice SQL Queries in local / Install Database in local :    • How to Install Oracle Database (19C) ...
IT Jobs without Coding :    • IT Jobs without coding with high sala...

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------