Complete SQL Subquery Using Comparison and Logical Operators | SQL Tutorial in Hindi 13
Вставка
- Опубліковано 26 лип 2024
- SQL Full Course Playlist 👇
• SQL Tutorial In Hindi
Like, Share & Subscribe Now :)
⭐ Subscribe for more SQL tutorials like this: bit.ly/3Fc7Gc6
👉 customer csv file: bit.ly/3KLPb2P
👉 payment csv file: bit.ly/41kIYjW
📢 GitHub link (all files): bit.ly/3Y7SRPr 📢
➖➖➖➖➖➖➖➖➖➖➖➖➖
Timestamps:
00:00 Intro
00:28 Subquery in SQL
01:27 Subquery Example Using Comparison Operator
02:11 Subquery practice in SQL
05:23 Subquery using IN Operator
08:01 Subquery using EXISTS Operator
➖➖➖➖➖➖➖➖➖➖➖➖➖
Target keywords: complete sql subquery, subquery tutorial, Subquery using comparison and logical Operator, nested query in sql, inner query in sql
➖➖➖➖➖➖➖➖➖➖➖➖➖
Related Videos
Introduction to SQL - What Is SQL + Database | SQL Tutorial In Hindi 1
• What Is SQL ? | Databa...
Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi 2
• Data Types, Primary-Fo...
Create Table In SQL & Create Database | SQL Tutorial In Hindi 3
• Create Table In SQL & ...
INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4
• INSERT UPDATE, DELETE ...
SELECT Statement & WHERE Clause with Example | Operators in SQL | SQL Tutorial in Hindi 5
• SELECT Statement & WHE...
How To Import Excel File (CSV) to SQL | Import Data From File | SQL Tutorial in Hindi 6
• How To Import Excel Fi...
String Functions in SQL | Functions in SQL | SQL Tutorial in Hindi 7
• String Functions in SQ...
Aggregate Functions in SQL - COUNT, SUM, AVG, MAX, MIN | SQL Tutorial in Hindi 8
• Aggregate Functions in...
Group By and Having Clause in SQL | SQL Tutorial in Hindi 9
• Group By and Having Cl...
TimeStamp and Extract Function | Date Time Function | SQL Tutorial in Hindi 10
• TimeStamp and Extract ...
Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 11
• Complete SQL JOINS For...
SQL SELF JOIN | UNION & UNION ALL in SQL | SQL Tutorial in Hindi 12
• SQL SELF JOIN | UNION ...
Useful videos
How to Become Data Analyst in 2022 | Data Analyst Roadmap
• How to Become Data Ana...
Data Analyst skills, jobs and Roadmap
• Data Analyst- Skills, ...
Excel Tutorial for Beginners
• Excel for Beginners | ...
➖➖➖➖➖➖➖➖➖➖➖➖➖
Connect on other Social Media handles:
Instagram: / rishabhnmishra
LinkedIn: / rishabhnmishra
Twitter: / rishabhnmishra
➖➖➖➖➖➖➖➖➖➖➖➖➖
If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh Mishra and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students.
Have a great day buddy!
Rishabh bhai, tum bohot mast teacher ho...concepts ek hi baar me samaj aajate hai and that too in a very structured manner. Keep it up!
Glad you liked it ✅️
bhai ap aise padhate ho jese revision karhe ho, apko as a newbie smjhana chahiye joki first time padhrha ho !!!
Okayy bhai, next time aur simple and slowly samjhayunga ✅️✅️
Rishabh bhai, tum bohot mast teacher ho...concepts ek hi baar me samaj aajate hai and that too in a very structured manner. Keep it up! Love you Sir. We are so happy for your teaching. dill se thankyou aapko.
Glad you liked ✅️
This video is about when a working professional teaches you. They will know every corner on how to make you understand the concept.
Glad you liked it ✅️
This video is very helpful for me
mene es se pehly bohat sari palylist ki or join wala topic samjhny ki koshish ki but phir b me paper me question krny ky qabil ni thi jesy h mene ap ki videos dekhi hy me join ky related kisi b qisam ka question achy se kr sakti ho
Thanks Again sir g👍
Excellent job sir salute 👏
Thanks a lot sir...
Aapka Tahe Dil se shukriya bhai.
Happy to help ✅️
Thank for this tutorial ! ❤
Glad you liked ✅️
I got new concept "सब कुछ ", Thanks a lot.
Glad it was helpful ✅️
Very nicely explained, Rishab. However, I have one request regarding this particular video. Could you kindly mention the question for the "Logical Operator & Exist Operator" before starting the chapter? Just like you did with the question for the "Compression Operator" at the beginning, it would help provide more clarity. The rest is okay. Thank you.
Glad you liked n Noted ✅️
bohot bdhiya
Thanks You explained in a easy and excellent way !!
Glad it was helpful! ✅️
U are teaching like we are knowing every thing
Fabulous explaination❤
Glad you liked ✅️
Wow this was an amazing video, I came here just to solve my doubt about subquery but now feels to watch all of your videos about sql. Really amazing video and I will also promote about you on my channel soon when i start my channel. This is how real professional helps to learners like us.
I would like to connect with you over linkedin so if you don't mind please drop your connection link.
Glad it was helpful! ✅️
LinkedIn link in video description
Well explained
very nice explanation...
Glad you liked it ✅️
Finished practicing
Bhai SQL ka sara topic samajh aaya pr ye sub query utna clear nhi hua...😢
Okayy, iske uppar phir se ek video bana dunga
very nice sir
Sir there is record in column which is split through (,). I want to remove every character that starts with coma and there are multiple like that in table. Is there a query which removes characters starts from coma now matter what there length is? Plez help
Rishab bhai ek video exadata par advantage
Aur normal database difference par video bana di bhai
when you have used in operator what is the role of mode in the line ?
Finished watching
Awesome ✅️
Sql ka ak pura video bhnay data analysis kh liy
already uploaded sql project
nice explanation...can you help me to understand the exact difference between IN and EXISTS operator in subquery...?
IN operator always picks the matching values list, whereas EXISTS returns the Boolean values TRUE or FALSE
In select the matching values
subquery apan use kab karte hai?
Can we use join and subquery at a time? If yes, please help me with complete syntax with these 2 tables (customer and payment) to get output
The answer is yes... I am sharing the syntax of something similar that I did ..
select C.custid,C.custname,O.order_qty from customer_test as C join orderid_test as O
on C.custid=O.custid
where C.custid in
(select custid from orderid_test)
Select * from customer where amount > avg(amount) is this correct
Sir ye date ka leya syntax bta degeye mtlb syntax kya hona chahiye
sir last mai nhi smjh aya kuch kab exist use kab In use krna hai .....and joins hi easy lga mujh to inse
Or sir existing table ke andr or data kese add kese krskte hain sir plz iska bhi jawab deden
make a videon temporal function in details like from year how to extract month
Okayy noted ✅️
is this enought to data analyst bro ?
Sir, mujhe SQL basic pata hai..kya mujhe course buy karna chahiye ?
can we prepare a subquery using HAVING clause?
Yess.. just like, we did with WHERE clause 😀
is there any website where we can practice some queries? Any suggestions?
Yes there are many like w3schools
hacker rank, leetcode , w3 school
Bhai bina subquery from me bhi lagti he, wo nhi bataya, uska alag video he ?
👍
Sir in bsc cs passout student what is career opportunities after bsc cs ...i depressed bcoz i think choose worse field track i should choose btech
do mca brother
you can persue that
subquery pr ek 2 hours ki video leh aao bhiya ?
Okayy noted ✅️
Sir plz ans my question 😢 sir 2 table ko join kese krskte hain koi column name same na ho sir plz iska ans deden
Sir aapka paid course bhi available hai if yes i glad to join it.
No paid course, only UA-cam 👍
bhaiya date year month dalte ni aa rha
Next video kab aayge
after 2 days :) only 2 more videos then course will be completed. After that we will practice for SQL interview questions, tricky questions,etc
I have completed all videos today. I will be soon practicing them. I'm working on SQL but don't know to create complex queries.
@@mohdabdulhameed2347 Advance or complex queries will come by practicing SQL questions. More you practice more you will learn.
Were got a SQL pdf sir
Link in video description
Bro please make one video on advanced sql & include all topics such as with Clause, cte rank, dense_rank, dynamic sql temporary function, pivoting, lead & leg, except vs not in, delta values, row_number, views, cast func., top func., Select into, sql index, sql transaction etc.
Okayy noted ✅️
the way you say sab kuch it irritates