Channel Avatar

ItJunction4all @[email protected]

13K subscribers - no pronouns :c

My name is Sunil Kumar. I am a Software Engineer. I have cre


Welcoem to posts!!

in the future - u will be able to do some more stuff here,,,!! like pat catgirl- i mean um yeah... for now u can only see others's posts :c

ItJunction4all
Posted 1 month ago

Data Analyst Vs Data Engineer Vs Data Scientist

14 - 0

ItJunction4all
Posted 2 months ago

Did you experience this ???

5 - 0

ItJunction4all
Posted 7 months ago

ITJunction4All wishes you all Happy Diwali 🎇🪔

7 - 0

ItJunction4all
Posted 9 months ago

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;

4 - 0

ItJunction4all
Posted 9 months ago

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

6 - 0

ItJunction4all
Posted 9 months ago

Which is faster UNION OR UNION ALL in SQL ?

6 - 0

ItJunction4all
Posted 9 months ago

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 - 2

ItJunction4all
Posted 9 months ago

What is the difference between ISNULL and COALESCE sql function?

6 - 4

ItJunction4all
Posted 1 year ago

Happy Chatth Puja🙏🙏

7 - 2

ItJunction4all
Posted 1 year ago

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

6 - 0