SQL Subquery in Hindi | Subquery in sql

SQL Subquery in Hindi | Subquery in sql
sql sub query video help you to learn different types of sub queries, single row sub query, multiple row sub query and correlated sub query in sql.
MS SQL Hindi Playlist : • SQL Tutorials-Hindi
MS SQL English Playlist : • SQL Tutorial-English
Power BI DAX Hindi Playlist : • DAX Hindi
Power BI DAX English Playlist : • DAX English
Power BI Hindi Playlist : • Power BI Tutorials-Hindi
Power BI English Playlist : • Power BI Tutorials-Eng...
#sqlserver #sql #sqlinterviewquestions #mssqlserver #sqlforbeginners #education #rdbms #sqlcourse #sqlcommands

[@sandipanmajumder9419]

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

[@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 😊

[@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

[@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

[@bishaldhakal5401]

Best explaination sir , you deserve more subscribe sir.

[@lotusamaze1142]

Thanks

[@amalasebastian9968]

amazing never stop teaching love from indore

[@lotusamaze1142]

Thank you, I will

[@PatelCollection]

Easy and Helpful Video! Thanks

[@lotusamaze1142]

Glad it was helpful!

[@pbbhosale9]

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

[@lotusamaze1142]

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

[@pritiranjanpatra3492]

Sir ye document provide karenge to bahut easy hojaega😊😊

[@azeemsher1291]

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

[@lotusamaze1142]

Thanks

[@Gudsan]

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

[@lotusamaze1142]

धन्यवाद

[@zahidimranx]

Thank you really so much for the explaining subqueries 😊❤

[@lotusamaze1142]

Happy to help!

[@bhaveshwagh4044]

Such a great expalnation sir ,
Thanks

[@lotusamaze1142]

Thanks for liking

[@user-rn8ji1pn3n]

Thank you for explaining it so well.

[@lotusamaze1142]

You're very welcome!

[@IrfanKhan-wv8rh]

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

[@lotusamaze1142]

You are most welcome

[@coding7241]

what a lovley video jst now subsribed

[@lotusamaze1142]

Thanks

[@abhishekshrivastav5066]

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

[@lotusamaze1142]

Most welcome

[@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

[@nileshgodase1007]

Amazing.... great sir👌👌👌👌

[@lotusamaze1142]

Thanks

[@ayazahamed8254]

Very well explained.

[@lotusamaze1142]

Glad it was helpful!

[@bharatsaraswat6653]

Awesome explanation Sir!

[@lotusamaze1142]

Glad you liked it

[@sagarthube1563]

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

[@lotusamaze1142]

Thanks a lot

[@Gyan_Hub_]

my frustration vanished now... thank you alot

[@lotusamaze1142]

You are welcome!

[@udaibhan3045]

Thanku sir

[@lotusamaze1142]

Thanks

[@karanmalkhede6689]

Best teacher great sir🙏🙏

[@lotusamaze1142]

Thanks

[@spiritualgyanhindi2681]

Tx sir..

[@lotusamaze1142]

All the best

[@Rohitkumar-vq1yk]

thank you sir ji

[@lotusamaze1142]

All the best

[@Yatin_Wagh]

Very nice explanation

[@lotusamaze1142]

Thanks

[@tusharsingh901]

Easy explanation of every concepts

[@lotusamaze1142]

Thanks

[@sandipanmajumder9419]

AGAIN IT'S A FANTASTIC!!! CHANNEL

[@lotusamaze1142]

Thanks again!

[@funandfazitee4359]

Thanks sir

[@lotusamaze1142]

Welcome

[@siddharthsingh5829]

Thankyou 😊🙏😊🙏

[@lotusamaze1142]

Most welcome 😊

[@demotube098]

Thanks

[@lotusamaze1142]

Welcome

[@tusharrawte7254]

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

[@lotusamaze1142]

You are most welcome

[@ms1sabsepyari]

very useful

[@lotusamaze1142]

Glad to hear that

[@jagdishgyanchandani1988]

Beautifully explained.

[@lotusamaze1142]

Glad it was helpful!

[@ritesh5898]

thanku sir

[@lotusamaze1142]

welcome

[@engineersINnight]

Sort and Supper.

[@lotusamaze1142]

Thanks

[@sagarthube1563]

Sir plzzz keep making videos...

[@lotusamaze1142]

We will

[@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?

[@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.

[@WalidhassanHassanwalid]

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.

[@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)

[@zohadaditto1307]

Sir make a video on median

[@lotusamaze1142]

very soon

[@jstafridi]

Sir could you please provide all class notes on SQL!

[@lotusamaze1142]

Pdf are for our registered students only

[@AliMohammad-vz5iy]

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

[@lotusamaze1142]

all covered for this topic

[@sid4380]

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

[@lotusamaze1142]

Yes, but it is paid.

[@SandhyaRani-ch9ib]

@@lotusamaze1142 How much..??

[@jigarparegi9020]

PDF MILEGI SIR?

[@lotusamaze1142]

please check education.lotusamaze.com/

[@rajeshpaul4052]

2nd highest wala query smj ni aaya

[@chhavirajsingh7226]

Ab sql plus ke jurat h

[@lotusamaze1142]

Sure

[@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..