Difference Between count(*) ,count(0),count(-1),count(col),count('youtube') | SQL Interview question

First view. Sir please share you you got into data analyst/engineer and courses you took sir please,..Big fan of you sir

My day starts or end with your channel videoes for SQL.
Discipline , practice and conquer.

Can you share any python channel as well if you know ?

Hi Ankit, Thanks for the video...Just want to inform you that I have cleared interview as an azure data engineer in your former company deloi**e...your videos were very helpful in clearing the interview..🙂🙂

Thanks Ankit for video. 👍

Best as always :)

much needed!

Hi Ankit, could you make a video on substr and instr... Thank you for for sharing your knowledge in the best way

Wow, you explained it so well.
This is one of the most common questions asked !!

Thnx alot

Congratulation for 7.89k Subscribbers.
Can you make a video on your Journey from First Job to till now? I believe it will really inspiring

Hi can you also write a query to fiind no. of worrking days in a year

Hi Ankit. Really good video about differences in count.🙂
But waht is difference between
select distinct cloumn and
select with group by? And also using both inone select satement.
Could you please explain. 🙏

Hi Ankit, Can you please make video on consecutive numbers. It is question number 180 on leetCode

Which of the following statement correct?
Question to viewers.
a) Zero,blank,null are same and represent same data
b) Distinct considers Null as well.
c)count(distinct column name ) doesnot consider Null.
d) All are correct

Sir, please make similar content on python as well. Will be very helpful

please make one video on difference between group by and partition by

Hi Ankit, another question being asked is that is there any difference in output time for query having count(*) VS count(1), basically is one faster than other or both will be executed in same time?

Tqsm Ankit . Appreciate your efforts

Thanks you so much Ankit 😊

Thanks sirji....Please make more videos It help a lot

My doubt cleared Ankit. Thankyou

If there is nodifference then why is it *, 1 etc?

Thanks very helpful

Why DB developer refer count(1) more than count(*)?

Thankyou so much! very clear explanation !

-- TABLE CREATION AND INSERTION QUERY.

CREATE TABLE emp (
emp_id INT,
emp_name VARCHAR(50),
salary INT,
manager_id INT,
emp_age INT,
dep_id INT,
dep_name VARCHAR(50),
gender VARCHAR(10)
);

INSERT INTO emp(emp_id, emp_name, salary, manager_id, emp_age, dep_id, dep_name, gender) VALUES
(1, 'Ankit', 14300, 4, 39, 100, 'Analytics', 'Female'),
(2, 'Mohit', 15600, 5, 48, 200, 'IT', 'Male'),
(3, 'Vikas', 12100, 4, 37, 100, 'Analytics', 'Female'),
(4, 'Rohit', 7260, 2, 16, 100, 'Analytics', 'Female'),
(5, 'Mudit', 15600, 6, 55, 200, 'IT', 'Male'),
(6, 'Agam', 15600, 2, 14, 200, 'IT', 'Male'),
(7, 'Sanjay', 12200, 2, 13, 200, 'IT', 'Male'),
(8, 'Ashish', 7200, 2, 12, 200, 'IT', 'Male'),
(9, 'Mukesh', 7000, 2, 51, 200, 'IT', 'Male'),
(10, 'Rakesh', 8000, 6, 50, 300, 'HR', 'Male'),
(11, 'Akhil', 4000, 1, 31, 500, NULL, 'Male'),
(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

Hi could you please help me out I am preparing for data analyst I have learned sql, python libraries and power bi. Do I need to learn any other things to grab a good opportunity?