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 - ...
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Auf dieser Seite können Sie das Online-Video SQL subquery assignment || Practice SQL Sub Query mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Coding Glitz 02 Oktober 2023 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 11,896 Mal angesehen und es wurde von 361 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
