ItJunction4all @[email protected]
13K subscribers - no pronouns :c
My name is Sunil Kumar. I am a Software Engineer. I have cre
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
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
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
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