HomeОбразованиеRelated VideosMore From: Easy Engineering Classes

SQL Nested Query - Insert, Update, Select and Delete using Sub Queries

372 ratings | 60635 views
SQL Nested Query - Insert, Update, Select and Delete using Sub Queries SQL tutorial for Beginners in Hindi and English
Html code for embedding videos on your blog
Text Comments (25)
Md Ariful Islam (3 months ago)
employee (employee name, street, city) , works (employee name, company name, salary), company (company name, city), manages (employee name, manager name) Question: delete the record of employees whose company name is "LU" and salary is greater than average.... how to find query? DELETE FROM works WHERE Company_name="Lu" AND (SELECT AVG(SalarY) FROM works); donot run why? i donot understand
Mohd Faiz (3 months ago)
Hi sir,, Sir i request you to start like oracle obiee tutorials,datawhere house,schema...like star schema and all schema's including all the topics(in Hindi) please.. sir
surprise motherf****r (6 months ago)
App serf apna pc meh tutorials kijiye best hey
Sunil Singh (7 months ago)
Very gud delivered
Syed Azmat (7 months ago)
Laptop me kharedonga ap k lye sir
Anju joshi (8 months ago)
Sir it will be enough for learning SQL programming??
hi5 fun (9 months ago)
WHEN YOU NEXT VIDIO UPLOAD SIR?
amar kn (9 months ago)
Thank you Easy Engineering Class
Vijay Magvaniya (9 months ago)
Sir ab dusare videos banana start kijiye or bhi
Dalbir Singh (10 months ago)
ur teaching technique is not good....
Trickpiwal (11 months ago)
Dala bhi ni
HCI EXPERT 2018 (1 year ago)
dont do if you cant do you r misleading peoples
HCI EXPERT 2018 (1 year ago)
Not explaining well
Sharad Dutta (1 year ago)
This guy is clearly bad in teaching.
Siddesh Gannu (1 year ago)
How would I do this using Joins sir? The first one. How would I have gone about doing the query using join? This is what I think I would have done: Select emp.ename, dept.dname from emp inner join dept on dept.dname = 'HR'; Is that correct? Thanks
Qurban Mirjat (1 year ago)
Waiting for #23
Awekening Dragon (1 year ago)
From where did you built manager table from thin air? At least use examples clearly so that us viewers dont get confused.
Mohammed Ahtisham (1 year ago)
interesting videos..i like it
Tariq Ahmed (1 year ago)
Thanks 'Easy Engineering Classes' To Strengthened And Increase My Study In Database, I Watched All Your 22 Videos And It Was Really Helpful.
Rohit Mondal (2 years ago)
please show in more detail on actual SQL of nested implementation.
Keshween Singh (2 years ago)
this sucks man i dont understand any shiT
David Manoharan (2 years ago)
sir insert in not clear. is manager a column in emp please clarify
madhur lohchab (1 year ago)
manager is another table ..be logical bro how can you run Select Commands on columns;
Shubham Singh (2 years ago)
when will next episode come??
Gitik Kaushik (11 months ago)
fuck outta here

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.