Sql window function Hindi | Window Function in Sql Hindi

Sql window function Hindi | Window Function in Sql Hindi
This video helps you to understand about window functions in sql. What is difference between rank and dense rank. Also explains about Row_Number(), Ntile, Over and partition by.
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

[@abhimanyutiwari100]

Dhyanyawad sir. Samjh me to hindi me hi aata hai.

[@lotusamaze1142]

Most welcome

[@pranitrevandkar5722]

true XD XD

[@careergyanshala2734]

Bilkul sahi kaha english me bak bak sun lo bs hindi me clear ho jata

[@anuppatil1061]

Yes. ❤️.

[@deadkachu7678]

Bhai aap jaisa aacha admi abhi tak nahi mila. Bhai meh 10 admi ka video dekha kuch samajh nahi aaya aapney step by step itna easily samjhaya. I subscribed and like ur video. Aap deserve kartey ho.

[@lotusamaze1142]

Thanks

[@indurana3256]

Thank you very much sir! This to the point explains the concept, you are a great teacher.

[@lotusamaze1142]

Glad it was helpful!

[@rajdhanibeats4060]

Beautiful explanation. I have watched many videos on Partition by. But this video is crystal clear to understand.

[@lotusamaze1142]

Glad it was helpful!

[@harshkaushal7073]

awesome explanation sirji , watched many videos but only got it clear through yours.

[@lotusamaze1142]

Glad to hear that

[@mathematicswestbengalboard1228]

Very well explained.. getting this kind of content in hindi is priceless.👍

[@lotusamaze1142]

Glad you like it

[@supratikpaul6403]

Best video I have found on window function Thanks a lot brother hope will see some more videos on SQL

[@lotusamaze1142]

Glad you liked it, SQL playlist in Hindi & English is already on channel

[@suyash7450]

Very well explained sir , Now I know how to use window and aggregate function together.

[@lotusamaze1142]

Glad to hear that

[@neerajkhadagade8634]

This is amazing! Loved it! You explained in a very simple manner and it was very east to understand!
Keep it up! :)

[@lotusamaze1142]

Glad you liked it!

[@user-kx6np6lv1l]

very nice sir.aap bilkul perfect tarah se samjhate ho har topic.

[@lotusamaze1142]

Thanks

[@49_sohamsawant67]

Superb PlayList. Very well explained. So useful for me in my SQl coding assesment.

[@lotusamaze1142]

Glad it was helpful!

[@the_invisible__]

Simple explanation....thank you sir....This channel deserves more subscribers.

[@lotusamaze1142]

Thanks and welcome

[@ai.201]

You are so good man. I was scared of these functions once

[@lotusamaze1142]

Thanks

[@dipakpoojary6618]

Wow sir wonderful explaination Thank you

[@lotusamaze1142]

Most welcome

[@sayantika_sengupta]

Amazing explanation, looking forward to more such videos

[@lotusamaze1142]

Thanks, Hindi & English play list on sql server is already there.

[@swaroopghag1098]

best explaination of window functions on entire yt

[@lotusamaze1142]

Thanks for liking

[@sadiasiddiqui3309]

Amazing explanation 👍 keep up the good work. Soon you’ll have millions of subscribers 👍

[@lotusamaze1142]

thanks for compliments

[@iv_08]

Very informative and useful video,
bhut acche se smjh aaya sir..
God bless you :)

[@lotusamaze1142]

thanks

[@deenkibaate972]

THANK YOU SIR FOR EXAPLAINING IN DETAIL

[@Buzzingfact]

Very nice explanation thank you

[@lotusamaze1142]

Glad you liked it

[@333Stan]

Thanks a lot for explaining. Was very helpful. God bless you.

[@lotusamaze1142]

Glad it was helpful!

[@avanendrasharma8244]

I was too confused with this topic. Thanks a lot sir🤗 you made it all clear

[@lotusamaze1142]

thanks

[@anujgaming5436]

Thank you sir I am glad to meet you the try again succes full to work me

[@lotusamaze1142]

Thanks

[@irfankhan-qj4mu]

thank you Sir , by heart superb content

[@lotusamaze1142]

So nice

[@rajanikanta999]

best video😀 i came across. Good job bro.

[@lotusamaze1142]

Glad it helped

[@stocksmafia3273]

kya padhate ho yar aap , aapka fan hogya mai

[@lotusamaze1142]

Thanks, , For Training Call or WA 91-8076787743

[@dikshachawla2475]

thanks,,,,,,bhut accha explain kiya hain hindi mein...

[@lotusamaze1142]

Glad, it helped

[@sudhanshu_kumar4497]

I watched many videos but This one is lucid explain
Thank you sir
After watching this my all concept of windows function is clear.

[@lotusamaze1142]

All the best

[@chayanchoudhury3042]

Excellent lecture...bahaut badhiya...banaya lecture aapne..

[@lotusamaze1142]

Thanks

[@vaibhavpatharkar6794]

Aap bahut accha padhate hai . Bhagwan apko sukhi rakhe .. 😊

[@lotusamaze1142]

Thanks

[@vaibhavpatharkar6794]

@@lotusamaze1142 cte ka class samajh nahi aaaya . Krupa kar ek aur class / video banaye. Dusre example ke sath

[@sudhanshusharma699]

you exp;ained everything very smoothly

[@lotusamaze1142]

thanks

[@u.pakkirappa8972]

Excellent teachings

[@lotusamaze1142]

Thanks and welcome

[@pranitrevandkar5722]

aysa koi nahi padaya aaj tak thank you so much

[@lotusamaze1142]

Thanks

[@lotusamaze1142]

Thanks

[@abhinavsingh4208]

Mauj Krdi Sir , Aisi videos aur lao. Keep Rocking !!

[@lotusamaze1142]

Sure

[@devashishghosh7497]

Over() window function is a replacement of group by

[@lotusamaze1142]

no but advance version of group by

[@satishchaurasia84ya]

Perfect explanations. Thanks a lot🙏

[@lotusamaze1142]

Most welcome!

[@simranbanwait]

Thankyou so much sir , this came in my interview

[@lotusamaze1142]

Thanks

[@rishitiwari716]

Great explanation.
please make video on Data Integrity, ACID Properties ,Normalization and views.

[@lotusamaze1142]

Sure

[@satishchoudhury1996]

Quite helpful...
Thank you sirji...

[@lotusamaze1142]

Most welcome

[@vishalkoundal5008]

easy and detailed explanation thxs for the video

[@lotusamaze1142]

Thanks

[@BachelorS_Lifee]

Thank u, It's very good teaching pattern sir upload pl Sql video also like trigger, procedure n all plzz

[@lotusamaze1142]

More than 60 videos on SQL Tutorials in hindi and english are on channel. Please check playlist

[@mainlykanchan8740]

Thank you so much 🙏🏼🙏🏼🙏🏼🙏🏼🙏🏼🎉🎉🎉🎉🎉🎉🥰🙏🏼🎉🥰🥰🙏🏼

[@lotusamaze1142]

You are so welcome For Training Call or WA 91-8076787743

[@nikhil09090]

very well explain sir thank you.

[@lotusamaze1142]

Thanks and welcome

[@indianmedia5696]

Thank you sir.. All concepts cleared.

[@lotusamaze1142]

All the best

[@shivayshakti6575]

Mast lecture thanks ❤️

[@lotusamaze1142]

Thanks for liking

[@bhavesh3913]

Great video sir

[@lotusamaze1142]

Thanks

[@IrfanKhan-wv8rh]

Nice explanation sir

[@lotusamaze1142]

Thanks for liking

[@muhammadabubakar6220]

well done gentleman

[@lotusamaze1142]

thanks

[@sachin6585p]

ery nice sir.aap bilkul perfect tarah se samjhate ho har topic

[@lotusamaze1142]

Thanks

[@tanushreenagar3116]

So 👌 nice thnk ☺ 😊 🙏 😌 🙂 you 😀 😄 so much

[@lotusamaze1142]

Most welcome 😊

[@siddhantvats9088]

Very well explained

[@lotusamaze1142]

Glad it was helpful!

[@rupeshpal7090]

Thank u,nice explanation

[@lotusamaze1142]

Thanks

[@up-to-date1795]

Thanks Sir ...❤

[@lotusamaze1142]

Thanks

[@pranavsinha5700]

Bohot badhiya. Lifesaver 😅😁😁

[@lotusamaze1142]

Thanking you

[@ankitchauhan1094]

thank you, sir

[@lotusamaze1142]

You are most welcome

[@hemangichaudhari3923]

Nice explanation..

[@lotusamaze1142]

Thanks for liking

[@harshmudgil4140]

Very good video 👍

[@lotusamaze1142]

Thank you 👍

[@simranbanwait]

kya samjhaya hai sir, thankyou so much

[@lotusamaze1142]

Thanks

[@rakeshthakur9403]

Thank you! Very good video with good explanation

[@lotusamaze1142]

Glad it was helpful!

[@prashantkanhere8454]

BOHOT BADHIYA SIR

[@lotusamaze1142]

धन्यवाद

[@ratnasingh2950]

wow nice explanation..

[@lotusamaze1142]

Thanks for liking, For SQL Training 91-8076787743

[@neerajkushwaha9275]

exjplain in a smooth and good way .
can you provide lacture PDF

[@lotusamaze1142]

Thanks

[@pranayrawat1]

bahut hi badhiya samjhaya sir.......!

[@lotusamaze1142]

Thanks

[@reddevil2646]

your videos are really good ,sir i have one doubt
what is the syntax for inserting multiple records in a single column in sql server.iam aware about update syntax but is there any alternate method??

[@lotusamaze1142]

Use STRING_AGG function, also check my new video on STRING_AGG

[@rishabhkjha92]

Thank you this has been very helpful ... :)

[@lotusamaze1142]

Glad it was helpful!

[@sanuanand7909]

Thanks

[@lotusamaze1142]

Welcome

[@ankitkalwar5570]

Excellent explanation, thanks a lot

[@lotusamaze1142]

Glad you liked it

[@androiddeveloperlpu301]

best explanation

[@lotusamaze1142]

Glad you think so!

[@abhishekmote7250]

Sir, I ran the same query at 4:30 but didn't get any error, I am using Mysql workbench.

[@samyakgaykwad5803]

sir , apne bahut achhe se samjaya . sql ke notes kaha pr milege sir

[@lotusamaze1142]

Thanks

[@hintsoftware]

Can we use where clause or any kind of filters in any way for each windows function seperately ?
We are unable to fully utilize window function without where clauses... or any trick to do so in sql server ?

[@lotusamaze1142]

First Filter the data and keep in separate table and use window function on that table

[@ishikamehta647]

thnkuu so much sir..vry helpful

[@lotusamaze1142]

Most welcome

[@ankitsaxena565]

Superb

[@lotusamaze1142]

Thanks 🤗

[@ShivamGupta-ou1lx]

Impressive

[@lotusamaze1142]

Thanks

[@Yzyou11]

Hi how convert varchar to bigint Datatype

[@lotusamaze1142]

if varchar contains only numbers then it can be done

[@theaayushsharmavines]

Love u love u love bidu

[@lotusamaze1142]

thanks

[@dipakpoojary6618]

Will you make a Tableau tutorial if the future?

[@lotusamaze1142]

sure

[@topcodeofficial]

gr8 !!

[@lotusamaze1142]

Thanks

[@sumitchaudhary5574]

thank you sir

[@lotusamaze1142]

Most welcome

[@pradipbhoir9720]

👌👌👌

[@lotusamaze1142]

Thanks

[@techtb2923]

👌👌👌👌👌

[@lotusamaze1142]

Thanks

[@lalithroy]

Hi Sir,
from where can I get the SQL script used in the video.

[@lotusamaze1142]

you have to write yourself

[@hindi-english1664]

please upload data also for practice...

[@lotusamaze1142]

sure

[@KHUSHAL_SOLANKI]

Is there any notes according this video?

[@lotusamaze1142]

We provide the pdf study material to our student only

[@jstafridi]

Please give us pdf sir!

[@lotusamaze1142]

Pdf are for our registered students only

[@nitinparkash971]

Around 12:50, why 2nd rank isn't showing ?

[@lotusamaze1142]

To get answer , please check the difference between rank and dense rank in video