Clear explanation 💯 For those asking for dataset: create table employee( emp_id int, emp_name varchar(20), dept_id int, salary int ); insert into employee values(1,'Ankit',100,10000); insert into employee values(2,'Mohit',100,15000); insert into employee values(3,'Vikas',100,10000); insert into employee values(4,'Rohit',100,5000); insert into employee values(5,'Mudit',200,12000); insert into employee values(6,'Agam',200,12000); insert into employee values(7,'Sanjay',200,9000); insert into employee values(8,'Ashish',200,5000);
I was looking for videos on Advance SQL but was still struggling with understanding the concepts. I really liked the explanation. It's time to practice a few questions ;) Thank you, can't wait for the next video :)
Very aptly explained. I was asked this window sql question in Gainwell interview. I couldn't answer as I were not aware of it. I searched for these functions and saw your video. It is very easily explained and very precise to the core.
Very good explanation and easier to understand. Earlier I'm unable to understand difference between these 3 functions now I'm clear. Thank you so much for this video.
All are amazing videos.Very clear experience. It is very useful to refresh the SQL before interview.I am working as AVP in citicorp.Thank you very much Recently I used ur amazing videos to clear interview. Thank you very much.
To get highest salary..i gues you should use dense_rank. Because we need 3rd highest salary we can't fetch from this example which you have given...Am I right???
Thanks for these..keep uploading and simplifying these concepts.. I hope to see some python,tableau content soon too.. Hope your channel reaches 100k fast..best wishes ..
Thank you so much 😊 I will start Tableau soon. I am thinking should I start with basic tutorials or direct scenario based questions just like SQL. Any suggestions?
Please can you maintain the English language only. Your content is very helpful & i think it will not benefit the larger audience if you speak any other language. You are a great teacher!!
great explanation and the best thing here is using small dataset to simplify concepts in a short span please help me why alias was added at the last to get output i want to visualize how it works.
Nice explanation sir but i have small doubts if we have 2 conditions like salary and joining date and i want look at the salary but if some employees salary equal then he will look joining date and salary both so how we can find the data can you explain 😛
Sir, @8:50 you got an error and then you fixed it with an alias. Could you please let me know why we need an alias(a) there?? I am a beginner and a little confused.. Please help!
Sir why did you use "From" two times at last query of the video jaha Department wise highest salary show karni hai .."From ( " And fir last mein bhi "From Emp" ? Even alias a toh kahi aaya hi nahi table mein ..please explain sir
Thanks for explaining in such simple language . I have one doubt regarding the interview question can that be solved by simply using GROUP BY department with max(salary)
@@ankitbansal6 : Can we use this query to get the highest salary from each department and display all columns, sub-query might not be best option/optimized way, please take a look and advice. select emp_id, emp_name, department_id , salary from employee where salary in (select max(salary) from employee group by department_id )
hello sir,i almost watch all of your videos and your videos have always given me useful insights.i'm an aspiring data analyst.i know the basic concepts of sql.i just want to know how to go on that next level where i can crack interviews with big companies.thank you
Sir, instead of using 'PARTITION BY' clause inside the rank statement, can't we use 'GROUP BY' department_id in the end of the query, in order to get the ranks as per salaries of the departments ?
Clear explanation 💯 For those asking for dataset:
create table employee(
emp_id int,
emp_name varchar(20),
dept_id int,
salary int
);
insert into employee values(1,'Ankit',100,10000);
insert into employee values(2,'Mohit',100,15000);
insert into employee values(3,'Vikas',100,10000);
insert into employee values(4,'Rohit',100,5000);
insert into employee values(5,'Mudit',200,12000);
insert into employee values(6,'Agam',200,12000);
insert into employee values(7,'Sanjay',200,9000);
insert into employee values(8,'Ashish',200,5000);
Thanks
u can insert using single insert query
create table employee(
emp_id int,
emp_name varchar(20),
dept_id int,
salary int
);
INSERT INTO employee (emp_id, emp_name, dept_id, salary)
VALUES (1, 'Ankit', 100, 10000),
(2, 'Mohit', 100, 15000),
(3, 'Vikas', 100, 10000),
(4, 'Rohit', 100, 5000),
(5, 'Mudit', 200, 12000),
(6, 'Agam', 200, 12000),
(7, 'Sanjay', 200, 9000),
(8, 'Ashish', 200, 5000);
This Explanation Blew my mind..!!
From Scaring.. To Caring..on SQL. its just because of u Guruji🙏🙏
Very good explanation, short and concise. It's the only video i would want to watch before my interview for quick revision.
Glad you liked it 😊
I was looking for videos on Advance SQL but was still struggling with understanding the concepts.
I really liked the explanation. It's time to practice a few questions ;)
Thank you, can't wait for the next video :)
Glad it was helpful!
Very aptly explained. I was asked this window sql question in Gainwell interview. I couldn't answer as I were not aware of it. I searched for these functions and saw your video. It is very easily explained and very precise to the core.
Very good explanation and easier to understand. Earlier I'm unable to understand difference between these 3 functions now I'm clear. Thank you so much for this video.
Absolutely good to watch with simpler explanations :-)
I didn't understand analytical function until I see this video.
Thank you for explain in simple word to understand. 👍
You are most welcome
neet work. nicely explianed. expecting more such videos. LIKED COMMMENTED & SUBSCRIBED.
Explained to the point. Cleared the doubt related to the difference between these all the functions.
Enjoy very topic you taught sir .. You have amazing teaching skill even these hard topic you cover very easily thank U
Thank you 😊
All are amazing videos.Very clear experience. It is very useful to refresh the SQL before interview.I am working as AVP in citicorp.Thank you very much Recently I used ur amazing videos to clear interview. Thank you very much.
Enhancing clarity leads to an interest in learning. Thank you Ankit.. !
This is by far the best approach to teaching the windows function. SUBBED right away!
Thank you 😊
It's simple and easily understandable. I haven't even understood earlier from the top RUclipsrs. Thanks for your efforts. Keep it up!
Thanks a ton
Thankyou .After lots of watching videos finally my concept is cleared here.
Glad to hear that😊
Understood teh concept in a very simple way. Thank you :)
Bro ye where clause vala kesey kiya ....mujmey to error show kr raha hai ki 'rnk unknown column in where clause
An absolute no-nonsense guide to window functions!
Thanks bhaiyya ❤️
Thanks Amar for watching 🙂
That's the simplest and most understandable explanation :) Thank You !!
Glad you liked it!
hatoff to big brother love from noida ................you cleared concept like piece of cake
Awesome
Really very good explanation sir! Thank you very much:)
Most welcome!
Very nicely explained and in easy to understand. Great job!
Glad you enjoyed it!
Thank you so much for your hard work. It's really very useful to understand the Analytical Functions.
Most welcome!
apka...pehla subcriber hoo main.....bhaiya ...please bring lots of practical videos used in real time
Sure bro 🙂
💎 videos glad I founded it on RUclips
thanks for lecture, according to the last example , RANK( ) can't solve for the second highest salary provided by the department . am I right?
Thanks very much for the clarity and in detailed explanation of the concepts !
Very good explanation, short and concise
Glad it was helpful!
Thank you so much for all your videos and explaining in simpler language.All videos are very helpful 😊
Amazing explanation.
Very good explanation.
Nice explanation
Great explanation Ankit. Keep on creating similar stuff, all the best!
Thank you 😊
short and good explanation in this video
Thank you Ankit this was very easy to understand. Can you post some more interview questions using RANK(), DENSE RANK() and ROW_number
There are many in my complex SQL problems playlist
bhai thanks bht sahi and ez way me samjhaya apne
Very nice videos. It cleared my concept around these functions. Thank you. Please let me know online where i can practise SQL queries.
Thank you. You can practice on the DataLemur website.
Very nicely explained!
Glad you liked it
It's very helpful Sir thank you please make more this types of vedio 😊
Keep watching
Good work bro well explained
Thank you Ankit ! it was a very simple and clear explanation.
Glad you liked it
Nice video!
🥰my doubt is cleared Excellent Explaination about ranks thanks a lot👍
👏
I found the entire video to be well explained. There is just one thing I need to understand
How did you know you had to use aliasing at 8:55?
Such a simple explanation to these 3 functions. Thanks Ankit :)
Most welcome!
Great video
Great explained! looking forward for more videos
To get highest salary..i gues you should use dense_rank. Because we need 3rd highest salary we can't fetch from this example which you have given...Am I right???
Yes, for getting highest salary we should use dense_rank.
great video
Thanks. please continue the good work.
Great Learning with you Ankit😊
It's my pleasure😊
Hi Ankit Bhai, if possible kindly create a video playlist on SQL how much it is required for Analytics domain.
Okay
This is superb... I recently came across to your channel and it is really helpful😊
Teacher's should teach like you..
Thank you 😊
Thanks for these..keep uploading and simplifying these concepts..
I hope to see some python,tableau content soon too..
Hope your channel reaches 100k fast..best wishes ..
Thank you so much 😊 I will start Tableau soon. I am thinking should I start with basic tutorials or direct scenario based questions just like SQL. Any suggestions?
@@ankitbansal6 No no start with direct scenario based questions / case study. We are fed with Tutorials.
Thanks Sir, very nicely explained..
Most welcome
Nice explanation.. I have a doubt performance wise rank or dense rank is better
Same performance
Please can you maintain the English language only. Your content is very helpful & i think it will not benefit the larger audience if you speak any other language. You are a great teacher!!
This is the only video in Hindi on my RUclips channel
Nicely explanation
Thank You Sir, Clear understood✌👌
Glad to hear that
great explanation and the best thing here is using small dataset to simplify concepts in a short span
please help me why alias was added at the last to get output i want to visualize how it works.
In SQL server it is mandatory to give alias to a sub query
wanted to know if the records need to be sorted? or the partition function itself will take care of it ?
Order by will take care of sorting
clear explanation
Hats off to your content👌👌
Nice explanation sir but i have small doubts if we have 2 conditions like salary and joining date and i want look at the salary but if some employees salary equal then he will look joining date and salary both so how we can find the data can you explain 😛
Sir, @8:50 you got an error and then you fixed it with an alias. Could you please let me know why we need an alias(a) there?? I am a beginner and a little confused.. Please help!
In SQL server you need to give alias to sub query
@@ankitbansal6 oh, I use MySQL, so I don't need to put alias, right?
@@samarjitmechie Alias is mandatory we have to give in mysql also
Simply amazing. Thank you so much
Can we use row_number() in this case as row number will be unique and we can select where rownumber=1.
Thanks Ankit, can you please let me know how we will decide when to use rank(), dense_rank() and row_number()
It depends on business use case. There is no thumb rule as such.
@@ankitbansal6 thankyou
Well explained sir
Sir why did you use "From" two times at last query of the video jaha Department wise highest salary show karni hai .."From ( "
And fir last mein bhi "From Emp" ? Even alias a toh kahi aaya hi nahi table mein ..please explain sir
Thanks for explaining in such simple language . I have one doubt regarding the interview question can that be solved by simply using GROUP BY department with max(salary)
In that case you will get just max salary for each department but not other columns in the output
@@ankitbansal6 : Can we use this query to get the highest salary from each department and display all columns, sub-query might not be best option/optimized way, please take a look and advice.
select emp_id, emp_name, department_id , salary from employee where salary in
(select max(salary) from employee group by department_id )
well explained 💯💯
Same question asked in my yesterday interview 👍👍
Great explanation sir....tq
Keep watching
Nice video sir please upload more videos with interview questions
Sure
Informative
Clear explanation. waiting for next video
Thank you 😊
In MySQL also all these queries and concepts are same ?? Or it's slightly different ?
It's same accross databases
@@ankitbansal6 Thank-you sir 🙏
Thank u so much for this video.
Please share me link for query using pivot in mysql
U explained very well
Thank you 😊
Really helpful
Glad it helped👍
Thanks for the video!
You're welcome!
Can you share the Amazon link to the mike you used? Also what software you used for Screen recording, voice recording and Video editing?
I use chrome extension for screen and voice recording.
So far not editing videos.
@@ankitbansal6 thanks man. Could you be more specific? Which Crome extension and Which mike you use?
Extension name is screen recorder and I use laptop microphone only.
All I want to say is, I LOVE YOU MAN
🙏
hello sir,i almost watch all of your videos and your videos have always given me useful insights.i'm an aspiring data analyst.i know the basic concepts of sql.i just want to know how to go on that next level where i can crack interviews with big companies.thank you
Just solve my complex SQL playlist yourself
very good explanation 😊
Glad you liked it
Thanks alot sir✨
Most welcome
Appreciated bro 👍
🤝
Good morning Sir where we can practice online SQL ?
Sir, instead of using 'PARTITION BY' clause inside the rank statement, can't we use 'GROUP BY' department_id in the end of the query, in order to get the ranks as per salaries of the departments ?
Group by doesn't give rank
@@ankitbansal6 ok thankyou for responding sir
@@ankitbansal6 SIR WHEN WE WILL USE PARTITION BY AND WHEN WE WILL USE GROUP BY IN RANK,DENSE RANK AND IN ROW_NUMBER. I AM CONFUSED PLEASE REPLY ME
Very nice explanation
Keep watching
JUST WOW
Hi Sir, could you please let us know how much nosql/mongodb we should know to get placed in product based companies. Thank you in advance.
Ankit, there are people who may not understand Hindi, for them can you create a same video in English completely. Thank you
This is the only video in Hindi on the channel. I will make it in English soon. 😃
Any english video for window functions
Clear and Crisp
Thanks for this!
nicely explained, bro
Thanks bro 😊
Great Explanation
Thank you 😊