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

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

[@amalasebastian9968]

amazing never stop teaching love from indore

[@lotusamaze1142]

Thank you, I will

[@PatelCollection]

Easy and Helpful Video! Thanks

[@lotusamaze1142]

Glad it was helpful!

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

[@zahidimranx]

Thank you really so much for the explaining subqueries 😊❤

[@lotusamaze1142]

Happy to help!

[@bishaldhakal5401]

Best explaination sir , you deserve more subscribe sir.

[@lotusamaze1142]

Thanks

[@Gudsan]

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

[@lotusamaze1142]

धन्यवाद

[@pbbhosale9]

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

[@lotusamaze1142]

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

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

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

[@abhishekshrivastav5066]

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

[@lotusamaze1142]

Most welcome

[@nileshgodase1007]

Amazing.... great sir👌👌👌👌

[@lotusamaze1142]

Thanks

[@Gyan_Hub_]

my frustration vanished now... thank you alot

[@lotusamaze1142]

You are welcome!

[@pritiranjanpatra3492]

Sir ye document provide karenge to bahut easy hojaega😊😊

[@bharatsaraswat6653]

Awesome explanation Sir!

[@lotusamaze1142]

Glad you liked it

[@sagarthube1563]

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

[@lotusamaze1142]

Thanks a lot

[@azeemsher1291]

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

[@lotusamaze1142]

Thanks

[@ayazahamed8254]

Very well explained.

[@lotusamaze1142]

Glad it was helpful!

[@coding7241]

what a lovley video jst now subsribed

[@lotusamaze1142]

Thanks

[@karanmalkhede6689]

Best teacher great sir🙏🙏

[@lotusamaze1142]

Thanks

[@tusharsingh901]

Easy explanation of every concepts

[@lotusamaze1142]

Thanks

[@udaibhan3045]

Thanku sir

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

[@jagdishgyanchandani1988]

Beautifully explained.

[@lotusamaze1142]

Glad it was helpful!

[@tusharrawte7254]

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

[@lotusamaze1142]

You are most welcome

[@spiritualgyanhindi2681]

Tx sir..

[@lotusamaze1142]

All the best

[@siddharthsingh5829]

Thankyou 😊🙏😊🙏

[@lotusamaze1142]

Most welcome 😊

[@sagarthube1563]

Sir plzzz keep making videos...

[@lotusamaze1142]

We will

[@Rohitkumar-vq1yk]

thank you sir ji

[@lotusamaze1142]

All the best

[@funandfazitee4359]

Thanks sir

[@lotusamaze1142]

Welcome

[@sandipanmajumder9419]

AGAIN IT'S A FANTASTIC!!! CHANNEL

[@lotusamaze1142]

Thanks again!

[@ritesh5898]

thanku sir

[@lotusamaze1142]

welcome

[@engineersINnight]

Sort and Supper.

[@lotusamaze1142]

Thanks

[@Yatin_Wagh]

Very nice explanation

[@lotusamaze1142]

Thanks

[@ms1sabsepyari]

very useful

[@lotusamaze1142]

Glad to hear that

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

[@demotube098]

Thanks

[@lotusamaze1142]

Welcome

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

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

[@sid4380]

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

[@lotusamaze1142]

Yes, but it is paid.

[@SandhyaRani-ch9ib]

@@lotusamaze1142 How much..??

[@AliMohammad-vz5iy]

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

[@lotusamaze1142]

all covered for this topic

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

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