SQL subquery assignment || Practice SQL Sub Query
In this video we have discussed 10 SQL Subquery questions.
Learn Subquery concepts: • Subquery in SQL || SQL Subquery tutorial w...
PF DDL & DML Statements: https://drive.google.com/file/d/1pqU1...
Questions: https://forms.gle/esorRDfJ7jJTPT1E7
------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------
1. Select all employee and salary who are earning more than employee 7839 : 00:50
2. Select employee name, salary, employee 7839 's salary for employess earning more than employee 7839 : 01:58
3. Select all detail of employee who belong to same department as employee 7839 : 02:55
4. Select all employee names, their salary and total average salary of all emplloyees who are earning more than the average salary : 03:30
5. Select all employee detail who are hired before BLAKE : 05:19
6. Select all employee name and salary who are earning more than BLAKE but less than KING : 05:42
7. select all department numbers which has more number of employees than department 10 : 06:17
8. select department names which has more number of employees working than department 10 : 07:19
9. Select all department names which has more number of employees working than 'ACCOUNTING' department : 08:20
10. Select 3rd highest salary : 09:04
------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------
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 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
SQL JOINS : • SQL Joins With Examples | SQL Joins Tutori...
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 - ...
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Sur cette page du site, vous pouvez voir la vidéo en ligne SQL subquery assignment || Practice SQL Sub Query durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Coding Glitz 02 octobre 2023, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 11,896 fois et il a aimé 361 téléspectateurs. Bon visionnage!
