Subquery in SQL || SQL Subquery tutorial with examples

Pubblicato il: 27 marzo 2022
sul canale di: Coding Glitz

137,745

3.8k

In this video we have discussed SQL Subquery in a very simple way with examples. Here we have discussed about single row subquery, multi row subquery, correlated subquery and how subqueries can be used in where clause, select clause and from clause. Different important queries are discussed using subquery which are very important for interviews.

Single Row Subquery: 00:00:34
Multi Row Subquery: 00:04:16
Correlated Subquery: 00:06:37
Find second highest Salary: 00:09:25
Subquery in FROM Clause: 00:11:44
Subquery in SELECT clause: 00:15:41

LinkedIn: www.linkedin.com/in/biplabparida

Please Find SQL Commands to create Employee and Department table to practice:
https://drive.google.com/file/d/1pqU1...

Please like & share the video.

Subscribe the Channel to keep watching intresting videos helpful for your career growth:

   / @codingglitz

--------------------------------------------------------------------------------------------

Learn SQL in 30 mins:    • Can You REALLY Become an SQL Expert in Jus...

--------------------------------------------------------------------------------------------

Checkout different playlists:

PLSQL Tutorial :    • PLSQL Tutorial || PL SQL tutorial for Begi...
Learn DBMS & SQL :    • SQL Tutorial for Beginners || SQL Playlist...

SQL Interview Questions and answers:    • sql interview questions and answers in Hindi

Java Interview Questions and Answers :    • JAVA Programs for interview

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 Questions and answers

Top 50 SQL Concepts Interview Questions and Answers :    • SQL Interview Questions And Answers

SUB QUERY :    • Subquery in SQL || SQL Subquery tutorial w...

Employee earning maximum salary in each department query :    • SQL Query to find Employee with maximum sa...

How to delete duplicate rows from any table (2 different solutions):    • SQL query to delete duplicate rows in sql ...

How to find Nth highest salary (3 different solutions):    • SQL query to find Nth Highest salary in SQ...

Tricky SQL Queries Part1 :    • SQL Tricky and Important Interview Questio...

Basics of Database :    • What is DBMS?  Learn Basics of DBMS || SQL...

SQL OPERATORS :    • Operators in SQL  || SQL Tutorial for Begi...

AGGREGATE FUNCTION:    • Aggregate function  || SQL Tutorial for Be...

GROUP BY :    • GROUP BY  & HAVING || SQL Tutorial for Beg...

Solve any Date related query :    • How to Solve any SQL Query related to Date...

How to use Substring :    • Substrings in SQL  | Learn SQL | SQL Tutor...

How to practice SQL Queries in local / Install Database in local :    • How to Install Oracle Database (19C) || Ho...
IT Jobs without Coding :    • IT Jobs without coding with high salary - ...

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

In questa pagina del sito puoi guardare il video online Subquery in SQL || SQL Subquery tutorial with examples della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Coding Glitz 27 marzo 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 137,745 volte e gli è piaciuto 3.8 mille spettatori. Buona visione!

994