SQL JOIN Practice question and answers
Вставка
- Опубліковано 21 вер 2024
- DDL n DML statements: docs.google.co...
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...
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Join condition is e.deptno=d.deptno. By mistake it's written as e.deptno=e.deptno. My apology.
Your way Of Explaination is so easy & Simple ...thank u for all Videos that u made before.
Kamal ke tutorials hain, Biplab, thank you so much!
Thanks 🙏
Very Nice way to explanation ❤
Thank u for this video....I was actually waiting for this solutions...
Please make more videos like this assignment query on overall sql ....it will be useful for us
Yes planning to do so
Thanks
It was very helpful :)
Glad it was helpful!
Please make video on Cast Function,Decode Function & also Window Functions
Window function you can find in playlist.
Sir 05:53 iss question me bhi apne btaya to Self join but apne likhaa hua hai left join . Is it correct or mistake hua?
Same table k saath join ho raha so self join hi hai.
@@CodingGlitz Thank you so much sir :)
there is some issue with creating table library , i donot know what's the issue
Ap ka youtube video ma or online course ma kiya difference ha ??? Kiya benefit ha agar ma online course buy karon tu
Online course nhn hai everything is on UA-cam.
Can u please send us table
data for dept,library, book. so we can practise.
Please check description
Sir library wala table pg admin 4 मैं insert nahi ho paa raha, error dikha raha hai ,
Syntax Oracle me kaam karega datatype change Karo kaam karega
My table is not created yet
i tried to learn sql for many days but 5 days i found your channel and it's really oswam. just to become a pro from beginner where to practice except hacker rank? can u pls guide me? Supoort from Kolkata
Thanks... You can try hackerrank and leetcode
e.dept_no=d.dept_no ryt?
Correct