SQL Subquery in Hindi | Subquery in sql

[@sandipanmajumder9419]

excellent channel for all SQL learners (my personal recommendation)
thank you, Sir,♥♥♥♥♥

[@lotusamaze1142]

Thanks

[@sandipmandavkar5037]

Ek number sirji thanks you ❤ ekdam notes ke sath shika te ho aap esse ekdam perfect samj aata he ,ase hi video banate rahiye

[@lotusamaze1142]

Thanks

[@aanchalsharma2567]

beautifully explained each and everything.Thankyou so much for providing such a valuable content at free of cost. i appreciate your efforts and the way you teach is just awesome.

[@lotusamaze1142]

My pleasure 😊

[@PatelCollection]

Easy and Helpful Video! Thanks

[@lotusamaze1142]

Glad it was helpful!

[@bishaldhakal5401]

Best explaination sir , you deserve more subscribe sir.

[@lotusamaze1142]

Thanks

[@amalasebastian9968]

amazing never stop teaching love from indore

[@lotusamaze1142]

Thank you, I will

[@azeemsher1291]

Great channel ,well as I want , Because Told every statement code in different way🙃🙃

[@lotusamaze1142]

Thanks

[@nileshgodase1007]

Amazing.... great sir👌👌👌👌

[@lotusamaze1142]

Thanks

[@pbbhosale9]

सर आपका सिखाने का तारिक अद्भुत है।
मुझे आपले व्हिडिओ से बहुत कुछ सिखाने मिल।
धन्यवाद

[@lotusamaze1142]

Glad it was helpful- खुशी है कि यह मददगार था

[@zahidimranx]

Thank you really so much for the explaining subqueries 😊❤

[@lotusamaze1142]

Happy to help!

[@Gudsan]

सर जी आपको बहुत - बहुत धन्यवाद
आज आपका ये वीडियो देखकर तो ऐसा लगता है कि जैसे
आज मुझे सचमुच मे पंख मिल गये हो

[@lotusamaze1142]

धन्यवाद

[@IrfanKhan-wv8rh]

wow sir.. so easy explanation .. thank you so much!

[@lotusamaze1142]

You are most welcome

[@raviranjansingh5527]

Thanks sir ,Making great video in dept, maza aayaga aaj new thing know that.Keep updating more vedio in sql or tsql.

[@lotusamaze1142]

Thanks and sure

[@abhishekshrivastav5066]

Thank you so much.....sir marking good video

[@lotusamaze1142]

Most welcome

[@bhaveshwagh4044]

Such a great expalnation sir ,
Thanks

[@lotusamaze1142]

Thanks for liking

[@MohitSharma-m4i]

Thank you for explaining it so well.

[@lotusamaze1142]

You're very welcome!

[@Ghostmode1563]

Bro u deserves subscribers in millions....🤗🤗😎😎😎

[@lotusamaze1142]

Thanks a lot

[@bharatsaraswat6653]

Awesome explanation Sir!

[@lotusamaze1142]

Glad you liked it

[@tanz3562]

Thank you 🙏🙏

[@lotusamaze1142]

Thanks

[@Manish247-R]

my frustration vanished now... thank you alot

[@lotusamaze1142]

You are welcome!

[@coding7241]

what a lovley video jst now subsribed

[@lotusamaze1142]

Thanks

[@karanmalkhede6689]

Best teacher great sir🙏🙏

[@lotusamaze1142]

Thanks

[@tusharrawte7254]

Thank you sir for elaborating Subqueries in very easy way..

[@lotusamaze1142]

You are most welcome

[@tusharsingh901]

Easy explanation of every concepts

[@lotusamaze1142]

Thanks

[@pritiranjanpatra3492]

Sir ye document provide karenge to bahut easy hojaega😊😊

[@sandipanmajumder9419]

AGAIN IT'S A FANTASTIC!!! CHANNEL

[@lotusamaze1142]

Thanks again!

[@ayazahamed8254]

Very well explained.

[@lotusamaze1142]

Glad it was helpful!

[@kinchalsharma3625]

Thank you for sharing. Requesting you to please share tables with us that you are using in videos. it is easy and time consuming for us to practice.

[@lotusamaze1142]

Thanks for suggesstion

[@vishalpoojary3686]

i need table too for practice which you have mentioned in this video@@lotusamaze1142

[@siddharthsingh5829]

Thankyou 😊🙏😊🙏

[@lotusamaze1142]

Most welcome 😊

[@Yatin_Wagh]

Very nice explanation

[@lotusamaze1142]

Thanks

[@neejudeshwal6515]

Thank You sir

[@lotusamaze1142]

Always glad to help!

[@jagdishgyanchandani1988]

Beautifully explained.

[@lotusamaze1142]

Glad it was helpful!

[@Rohitkumar-vq1yk]

thank you sir ji

[@lotusamaze1142]

All the best

[@DailyDiary4U]

create table Student_marks
(RollNo int, Sciences int, Math int, Eng int)
Insert into Student_marks values
(1,34,78,54),
(2,78,43,87),
(3,58,25,89),
(4,68,58,76),
(5,96,78,84),
(6,78,85,78),
(7,78,58,78),
(8,78,86,88),
(9,58,74,75),
(10,74,82,74)

[@SandipanSarkar-c8v]

Finished watching

[@lotusamaze1142]

Thanks

[@Waleeduog]

Sir agar ma use krta hu where clause ma k where rollno =1 tu muja record pir b show hu ga tu subquery ku use ki

[@lotusamaze1142]

it depends on complexity of query, if query is very complex then break into small i.e sub query otherwise you can use in single query.

[@demotube098]

Thanks

[@lotusamaze1142]

Welcome

[@ms1sabsepyari]

very useful

[@lotusamaze1142]

Glad to hear that

[@spiritualgyanhindi2681]

Tx sir..

[@lotusamaze1142]

All the best

[@engineersINnight]

Sort and Supper.

[@lotusamaze1142]

Thanks

[@SandipanSarkar-c8v]

Finished practicing

[@lotusamaze1142]

Thanks

[@niharikashrivas9739]

Tysm sir for ur notes

[@lotusamaze1142]

I also provide online classes on sql, power bi, azure and other data engineering topics and helping students for placement.

[@akkiwadhwa6618]

@@lotusamaze1142 power bi, azure and other data engineering topics are uploaded on this channel?

[@funandfazitee4359]

Thanks sir

[@lotusamaze1142]

Welcome

[@Ghostmode1563]

Sir plzzz keep making videos...

[@lotusamaze1142]

We will

[@ritesh5898]

thanku sir

[@lotusamaze1142]

welcome

[@AliMohammad-vz5iy]

Did we miss any add on topics for subqueries, please advise.

[@lotusamaze1142]

all covered for this topic

[@Shivya648]

Can't we resolve the first question by join function?

[@sadhanachoudhary6295]

when City='noida', there is only 2 records fetch from second select statement...then how >any will be applied??

[@lotusamaze1142]

city='noida' returns rollno 6,7 from student table. >any operator will return rollno greater than 6 or 7 i.e 7,8,9,10 from student_marks table.

[@zohadaditto1307]

Sir make a video on median

[@lotusamaze1142]

very soon

[@sid4380]

I'm looking for these notes. Sir Can you share these notes?

[@lotusamaze1142]

Yes, but it is paid.

[@SandhyaRani-ch9ib]

@@lotusamaze1142 How much..??

[@jstafridi]

Sir could you please provide all class notes on SQL!

[@lotusamaze1142]

Pdf are for our registered students only

[@rajeshpaul4052]

2nd highest wala query smj ni aaya

[@jigarparegi9020]

PDF MILEGI SIR?

[@lotusamaze1142]

please check education.lotusamaze.com/

[@Fraction4543]

NOT IN comparison operators.

[@lotusamaze1142]

I dont understand what you say.

[@Fraction4543]

'Not in' bhi comparison operators ka part hai na...just asking questions for confirmation..

[@chhavirajsingh7226]

Ab sql plus ke jurat h

[@lotusamaze1142]

Sure

[@SandipanSarkar-c8v]

Finished watching

[@udaibhan3045]

Thanku sir

[@lotusamaze1142]

Thanks