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 😊

[@PatelCollection]

Easy and Helpful Video! Thanks

[@lotusamaze1142]

Glad it was helpful!

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

[@zahidimranx]

Thank you really so much for the explaining subqueries 😊❤

[@lotusamaze1142]

Happy to help!

[@pritiranjanpatra3492]

Sir ye document provide karenge to bahut easy hojaega😊😊

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

[@amalasebastian9968]

amazing never stop teaching love from indore

[@lotusamaze1142]

Thank you, I will

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

[@pbbhosale9]

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

[@lotusamaze1142]

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

[@Gudsan]

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

[@lotusamaze1142]

धन्यवाद

[@bishaldhakal5401]

Best explaination sir , you deserve more subscribe sir.

[@lotusamaze1142]

Thanks

[@user-rn8ji1pn3n]

Thank you for explaining it so well.

[@lotusamaze1142]

You're very welcome!

[@azeemsher1291]

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

[@lotusamaze1142]

Thanks

[@bhaveshwagh4044]

Such a great expalnation sir , Thanks

[@lotusamaze1142]

Thanks for liking

[@Gyan_Hub_]

my frustration vanished now... thank you alot

[@lotusamaze1142]

You are welcome!

[@IrfanKhan-wv8rh]

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

[@lotusamaze1142]

You are most welcome

[@sagarthube1563]

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

[@lotusamaze1142]

Thanks a lot

[@abhishekshrivastav5066]

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

[@lotusamaze1142]

Most welcome

[@tusharrawte7254]

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

[@lotusamaze1142]

You are most welcome

[@tusharsingh901]

Easy explanation of every concepts

[@lotusamaze1142]

Thanks

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

[@bharatsaraswat6653]

Awesome explanation Sir!

[@lotusamaze1142]

Glad you liked it

[@coding7241]

what a lovley video jst now subsribed

[@lotusamaze1142]

Thanks

[@udaibhan3045]

Thanku sir

[@lotusamaze1142]

Thanks

[@nileshgodase1007]

Amazing.... great sir👌👌👌👌

[@lotusamaze1142]

Thanks

[@Rohitkumar-vq1yk]

thank you sir ji

[@lotusamaze1142]

All the best

[@karanmalkhede6689]

Best teacher great sir🙏🙏

[@lotusamaze1142]

Thanks

[@ayazahamed8254]

Very well explained.

[@lotusamaze1142]

Glad it was helpful!

[@jagdishgyanchandani1988]

Beautifully explained.

[@lotusamaze1142]

Glad it was helpful!

[@spiritualgyanhindi2681]

Tx sir..

[@lotusamaze1142]

All the best

[@siddharthsingh5829]

Thankyou 😊🙏😊🙏

[@lotusamaze1142]

Most welcome 😊

[@sagarthube1563]

Sir plzzz keep making videos...

[@lotusamaze1142]

We will

[@sandipanmajumder9419]

AGAIN IT'S A FANTASTIC!!! CHANNEL

[@lotusamaze1142]

Thanks again!

[@demotube098]

Thanks

[@lotusamaze1142]

Welcome

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

[@ritesh5898]

thanku sir

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

[@Yatin_Wagh]

Very nice explanation

[@lotusamaze1142]

Thanks

[@ms1sabsepyari]

very useful

[@lotusamaze1142]

Glad to hear that

[@engineersINnight]

Sort and Supper.

[@lotusamaze1142]

Thanks

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

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

[@sid4380]

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

[@lotusamaze1142]

Yes, but it is paid.

[@SandhyaRani-ch9ib]

@@lotusamaze1142 How much..??

[@rajeshpaul4052]

2nd highest wala query smj ni aaya

[@AliMohammad-vz5iy]

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

[@lotusamaze1142]

all covered for this topic

[@jigarparegi9020]

PDF MILEGI SIR?

[@lotusamaze1142]

please check education.lotusamaze.com/

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