CASE WHEN END STATEMENTS IN SQL | Advanced SQL | Ashutosh Kumar

Sql one of the most important language asked in most of the analytics interviews,in this series i have discussed some advanced level sql concepts that are frequently asked in data analyst,business analyst interviews. In this video i have covered CASE WHEN END STATEMENTS concepts in sql
👉Query -
drop table if exists table1;
create table table1(
ID varchar(133),
name varchar(133)
);
insert into table1 (id,name)
values ('n1','AS'),
('n2','BR'),
('n3','GA'),
('n4','GJ'),
('n5','HR');
----------------------------------------------------------------
drop table if exists table2;
create table table2(
orderID varchar(133),
custid varchar(133),
sale integer
);
insert into table2 (orderid,custid,sale)
values ('1','1','936'),
('2','2','698'),
('3','3','232'),
('4','4','672'),
('5','5','413');
-----------------------------------------------------------------
drop table if exists table3;
create table table3(
name varchar(133),
height integer
);
insert into table3 (name,height)
values
('n1','259'),
('n2','204'),
('n3','154'),
('n4','188'),
('n5','236');
select * from table3;
------------------------------------------------------------------
👉 Complete playlist on Sql Interview questions and answers
• HackerRank SQL problem...
---------------------------------------------------------------------------------------------------------------------
Check out some more relevant content here
👉 How to Learn SQL
• How to learn sql for b...
👉 How to become a business analyst complete roadmap-
• Business Analyst Compl...
👉 How to become a data analyst complete roadmap-
• Data Analyst Complete ...
👉 Top 3 you tube channels to learn sql for free for beginners
• Video
👉 Rank ,Dense Rank, Row Number in sql -
• RANK - DENSE RANK - RO...
👉 Cross join in sql
• CROSS JOIN SQL
👉 union join in sql
• UNION IN SQL
👉 left join in sql
• LEFT JOIN IN SQL
👉 Right join in sql
• RIGHT JOIN IN SQL
👉 Inner join in sql
• INNER JOIN IN SQL
👉 Introduction to tables and databases in sql -
• INTRO TO TABLES AND DA...
👉 Aggregate Function in sql
• AGGREGATE FUNCTION IN SQL
👉 Functions in sql-
• IMPORTANT FUNCTIONS IN...
👉 String Function in sql
• STRING FUNCTIONS IN SQL
👉 CRUD operations in sql
• CREATE- READ- UPDATE-D...
👉 Autoincrement in sql
• Auto Increment in SQL ...
👉 Primary Key in sql-
• PRIMARY KEYS IN SQL - SQL
👉 Null and Default values in sql-
• NULL AND DEFAULT VALUE...
👉 Data types in sql-
• Data types in Sql - SQL
____________________________________________________________________
Fill the form below to subscribe yourself to the analytics jobs mailing list to receive regular job opening updates - docs.google.com/forms/d/e/1FA...
Why you should definitely fill the analytics job updates google form - • Job Openings into busi...
_______________________________________________________________________
Connect with me
📸Instagram - / ashutosh.analytics
💻Linkedin- / ashutoszh
_____________________________________________________________________
Comment down if you have any doubts
Please leave a LIKE 👍 and SUBSCRIBE ❤️ to my channel to receive more amazing content in data analytics and data science.
_____________________________________________________________________
🏷️ Tags
sql,
sql for data science,
sql for data analytics,
sql practise questions,
sql practise questions and solutions,
sql tutorials for beginners,
sql problems for data engineers,
ashutosh,
ashutosh kumar,
ashutosh kumar analytics,
sql problems easy,
sql problem medium,
sql problems hard,
sql window functions,
sql advanced questions,
rank functions in sql,
lag lead in sql,
sql interview questions and answers,
sql interview questions,
sql questions asked in interviews,
hackerrank sql solutions,
hackerearth sql solutions,
leetcode sql solution
🏷️HashTags
#sql #interviews #questions #solutions

[@AshutoshKumaryt]

Advanced sql playlist (must watch) - ua-cam.com/play/PLbTF1OfX62c3RQ_ZFfyNBWVPdz_OWTMLG.html

[@VeereshforTech]

Video on how to explain data analyst projects in interview like python eda projects and SQL+ tabluea projects and and SQL + excel projects

[@antrasingh3863]

Congratulations for 10000 sub 😀👍🎉❤️

[@RaushanKumar-wm1ek]

That is some real dedication from you to contribute to this society. We have discussed regarding case when and you have made it. Hats off to you for your shear dedication and hard work. Keep it up bro❤

[@AshutoshKumaryt]

Thanks Raushan ,

[@maheshaekunde3877]

comment no 002- do one project on e-commerce

[@moviebuff3030]

I used case when statement for updating a single row of a column, it make the desired changes but it converted else row as NULL, so i guess its better to use only normal update statement for updating a single row data

[@Sandeepsingh-nv4lg]

Hi Ashutosh a very warm good morning for the new vedio

[@AshutoshKumaryt]

u can mail ur question on [e-mail]

[@Sandeepsingh-nv4lg]

I would like to make the vedio related to case when statement when the question is supposed to solve by using case when but in first time reading the question the window function is coming in mind

[@Sandeepsingh-nv4lg]

Like the one question had asked to populate the month ,order value , currect month order value , previous month order value type then what happened I was doing it by lag function for previous month order value something like that but that was incorrect

[@ayushsahu632]

congratulations ashu.....

[@AshutoshKumaryt]

Thanks but for what ?

[@ayushsahu632]

@@AshutoshKumaryt for 10k subscribers.. I got a Job as data analyst.. your videos help me a lot in my journey.. SQL tutorial videos and SQL project videos help me a lot. Project videos help me to enrich my portfolio.. and your tutorial videos give me concept clarity.. I wanna send you this message in email but not getting enough time from last month..
Thanks .. for your efforts.. your hard work, and commitment.
You are helping n number of people..
Hat's off to you.. You are serving great cause in society..
Regards

[@AshutoshKumaryt]

@@ayushsahu632 bahut bahut dhanyawad mere bhai , [e-mail] mera mail id ha let's connect

[@ayushsahu632]

@@AshutoshKumaryt sure

[@shubhamgupta9323]

i was trying to update the column using case function in MYSQL it was showing error that we need to use where clause.

[@AshutoshKumaryt]

Make sure your syntax is right

[@srrkarzaman223]

No project videos ? Can we expect

[@AshutoshKumaryt]

yes

[@user-qn8nw7js8w]

I think you have already decided to not to upload project videos 😮.

[@AshutoshKumaryt]

No no i wil

[@grvmavi]

Thanks ..can i get your contact number Ashutosh.. need to get some guidance regarding my future. I am plsql developer for last 11 years.