Subqueries in sql Part 59

Dear Sir,
you made excelent examples. Very intuitive and helpful. Far better than the most I found via internet.
Hope you will continue with great work
Best wishes

this man is a hero, a legend and a god!!

Thank you sir. your videos are very helpful.

sir plz make some toturials on php's framework laravel....

This video clearly and concisely explains subqueries thoroughly. The explanation is awesome and simple to understand. Thank you, Sir! Your videos are really good to understand the concepts of .Net and SQL Server.

Hi Venkat,

Your videos are very simple yet very helpful. You make things really easy for people to understand.Keep up the good work Cheers :)

hi all, I am students, and I am working on my project. I have to create below requirements :

1. Prepare the specifications of semi structured extensions to your Database. Minimal Requirements: 3 extensions in data model and 5 operations on XMP data. Each extension of data model should be described with: name, affected relations, the method of storage of XML used i.e. CLOB, XMLType, CHAR. Each description of operations on semi structured data should be described with: name, corresponding SQL operation from workload, tools used for implementation i.e. SAX, DOM, XPATH, XQUERY.

2. Implementation of at least 3 semi structured extensions to data model.

3.Implementation of at least 5 operations on semi structured data. Document the execution times with semi structured extensions.

I created database and I use SQL SERVER 2012. So can any one tell me what should I do for these ?

Plz give me good example and explain me ..thank you .

Thank you so very much for your very clear and understandable examples. They caused me to look at your other playlists and I plan to be watching many, MANY more of your tutorials. Again, thank you!

Thank you Venkat. This is next topic i have learned sth new. Keep goin'
I'm going further and further learning SQL with your videos.

sir,your class good but one suggestion but the veiw is not clear can you zoom it and show

best course of SQL, thanks man

what an explanation , thanks sir <3 <3

Great examples, keep up the good work!

thankyou venkat it's verry helpfull

You are awesome

Thanks for these videos. Can u make s video on nested subquery?

While writing the second query where we need to find the name and no of quantity sold, why have you used left join?

Sir, I want your database script. So from i would get that?plz....

amazing videos sir, please keep uploading videos and we will keep watching
:)

all your videos are excellent if you release updated versions of your courses on udemy or another site I will buy them guaranteed. I highly recommend his c# videos as well.

really this channel have good stuff and SQL concepts.

Better example for Sub-query would be to show Total Sales (select Sum(sls) from tblsls) as total and total percentage for each product. This is bit more difficult to achieve with joints Sub-query is pretty handy in that situation

Awesome!! Good examples.

Hi, thanks for sharing. May I know is "Subqueries" the same as "Nested SELECT"?

Thanks, good instruction. I recently had an exam and messed this up, but now I get it.

this was very helpful thank you

Can anyone let me know that in the second example, why didn't he put a group by in sub query, but he put it in join?

var notsaledProducts = db.tblProducts.Select(e => e).Where(e=>e.tblProductSales.Count<=0).ToList();
linq

Really salute sir... I saw ur all vedios... no words .... Verry easy to understand... Verry nicely u have explained all concept.... Easily I can clear interview

You are a very good instructor.

awesome content

Gets excited when Venkat says "Look at this" 😊

Updated test
Create Table tblProducts
(
Id int ,
Name nvarchar(50),
Description nvarchar(250),
PRIMARY KEY(Id)
)

Create Table tblProductSales
(
Id int ,
ProductId int,
UnitPrice int,
QuantitySold int,
PRIMARY KEY(Id),
FOREIGN KEY (ProductId) REFERENCES tblProducts(Id)

);

INSERT INTO tblProducts (Id,Name,Description) values (1,'TV', '52 inch black color LCD TV')
INSERT INTO tblProducts (Id,Name,Description) values (2,'Laptop', 'Very thin black color acer laptop')
INSERT INTO tblProducts (Id,Name,Description) values (3,'Desktop', 'HP high performance desktop')

INSERT INTO tdlproductsales (Id,ProductId,UnitPrice,QuantitySold) values (1,3,450,5);
INSERT INTO tdlproductsales (Id,ProductId,UnitPrice,QuantitySold) values (2,2,250,7);
INSERT INTO tdlproductsales (Id,ProductId,UnitPrice,QuantitySold) values (3,3,450,4);
INSERT INTO tdlproductsales (Id,ProductId,UnitPrice,QuantitySold) values (3,3,450,9);

just wanted to know which is faster subquery or join.
or it depends on indexing?

this playlist is gr8, can you make a SQL server DBA tutorial please we need your help and you are a gr8 teacher and a Xamarin tutorial for beginners will be awesome you are a master when it comes to programming tnx a lot I have learned a lot from you and still

You are Magician of SQL SERVER

Your videos are helpful even after 8 years. Thank you

you are the best SQL tutor i have ever had. Keep up the good work

Cleared my interview🙏

Kudos venkat🙏

Great

you are the best teacher

I am using not exists or exists, got to try IN.

you are awesome teacher

you made this tutorial 11 years ago🙃

Hello Sir.

Thank you so much for the utmost informative lessons & brilliant teaching method. I am following you since long and honestly, I learned and still learning SQL from your lessons.

Thank you so much for this unique lessons and teaching method & I recommend your channel as best place for learning SQL🌟💯⭐.

Lots of love and respect from Kabul, Afghanistan.❤🙏

Even though the video is posted 12 years ago, the examples that you take to explain are way too complicated to understand for somebody who is learning sql for the first time. Most of the time I forget about the objective of the topic and waste my time understanding what operation you are performing to get what idk.

I appreciate your efforts in preparing and uploading these videos which i found very helpful and very explanatory. I get excited to watch the videos and try the syntaxs. Thank you Venkat, keep uploading such invaluable videos. If you can make videos that can help in tackling the microsoft certification preparation topics, that would be great.