My name is Sunil Kumar. I am a Software Engineer. I have created YouTube channel ITJunction4All to share my knowledge. I will be posting videos on SQL, Python and Excel tutorials and interview questions & answers. I am hoping that whoever follows my channel will be benefiting from it. Lastly, if you are new to my channel, please subscribe my channel for all future video updates. I can assure that my channel will impart good knowledge to all my viewers.

Thanks


ItJunction4all

ITJunction4All wishes you all Happy Diwali πŸŽ‡πŸͺ”

2 months ago | [YT] | 6

ItJunction4all

Given table Emp(null represents blank value):
NAME
-----------

"John"

null

"Mary"
null
"Albert"
"Cindrella"
"Mark"



What will be the output for the below 2 queries:



Q1) SELECT COUNT(*) FROM Emp;

Q2) SELECT COUNT(name) FROM Emp;

5 months ago | [YT] | 4

ItJunction4all

In SQL, what is the difference between CHAR and VARCHAR data types ?

5 months ago | [YT] | 5

ItJunction4all

Which is faster UNION OR UNION ALL in SQL ?

5 months ago | [YT] | 5

ItJunction4all

What will be the result of below SQL query ?
SELECT SUM(Salary) , COUNT(SALARY) FROM Employees (Assume there are no records in the table )

5 months ago | [YT] | 4

ItJunction4all

What is the difference between ISNULL and COALESCE sql function?

5 months ago | [YT] | 5

ItJunction4all

Happy Chatth PujaπŸ™πŸ™

1 year ago (edited) | [YT] | 7

ItJunction4all

Happy Diwali to All ! May your life be filled with endless joy and achievements !

1 year ago | [YT] | 6

ItJunction4all

Such a proud Moment, Reached the 10k Mark and Still Counting. Moving Toward 20k. Thanks to all our Loyal Followers for your Support. The continued appreciation and response from you all guys helped me to reach this position. Much love! ❀️youtube.com/shorts/tdT6BtR-nM...

1 year ago (edited) | [YT] | 6

ItJunction4all

Happy Independence Day to AllπŸŽ‰πŸŽŠ

1 year ago | [YT] | 7