CASE Statement in SQL with Examples | SQL Tutorial for Beginners in Hindi

In this video we have discussed CASE statement in SQL with the help of different examples. We have discussed the common mistakes and tricky questions where students get confused. We have discussed how to use CASE statement in SELECT, UPDATE and ORDER BY CLAUSE.
Syntax : 00:45
1st Example in select clause : 01:30
Common Mistake : 03:05
CASE in Update : 05:00
Tricky example : 06:53
CASE in ORDER BY clause : 08:42
DDL / DML : drive.google.c...
Please like & share the video.
LinkedIn: www.linkedin.com/in/biplabparida
Subscribe our Channel to keep watching intresting videos helpful for your career growth:
/ @codingglitz
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout different playlists:
PLSQL Tutorial : • PLSQL Tutorial || PL S...
Learn DBMS & SQL : • SQL Tutorial for Begin...
SQL Interview Questions and answers: • sql interview question...
Java Interview Questions and Answers : • JAVA Programs for inte...
IT Career guidance: • Career Guidance
Interview Tips : • Interview Tips
IT Essentials and Tricks : • IT Essentials and Tricks
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout Important videos :
Top 30 SQL Queries Interview Questions and Answers : • SQL Queries Interview ...
Top 50 SQL Concepts Interview Questions and Answers : • SQL Interview Question...
SQL JOINS : • SQL Joins With Example...
SUB QUERY : • Subquery in SQL || SQL...
Employee earning maximum salary in each department query : • SQL Query to find Empl...
How to delete duplicate rows from any table (2 different solutions): • SQL query to delete du...
How to find Nth highest salary (3 different solutions): • SQL query to find Nth ...
Tricky SQL Queries Part1 : • SQL Tricky and Importa...
Basics of Database : • What is DBMS? Learn B...
SQL OPERATORS : • Operators in SQL || S...
AGGREGATE FUNCTION: • Aggregate function ||...
GROUP BY : • GROUP BY & HAVING || ...
Solve any Date related query : • How to Solve any SQL Q...
How to use Substring : • Substrings in SQL | L...
How to practice SQL Queries in local / Install Database in local : • How to Install Oracle ...
IT Jobs without Coding : • IT Jobs without coding...
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

[@datalover120]

You are life saviour..amzing explanation

[@CodingGlitz]

Thanks 👍

[@badnaam-bachelors516]

simple explanation but effective

[@nishakushwah1776]

Any video on data cleaning in SQL?

[@CodingGlitz]

Not yet

[@gauravsingh8274]

Nice video

[@CodingGlitz]

Thanks

[@Iamsomewrita]

Hi..Did you make any video on Partitions?

[@CodingGlitz]

kzbin.info/www/bejne/bqTWZWeEdp6Zgdk

[@Iamsomewrita]

@@CodingGlitz No sir i am not talking about window functions.I am talking about partitioning of a table like Hash partition,List,Range partition etc.

[@CodingGlitz]

No not yet