We need videos on window functions and common table expressions (CTE). These will be very helpful. Additionally, we want to create more difficult questions in part 2 that are asked by top MNCs, as the current ones are too easy.
Hi Riti Kumari madam I hope you're doing well ,your explanations are easy to understand as well as easy to feed information into the brain ,is there any possibility to do some excel interview questions also no one is doing about Excel interview questions also it helps lot who are preparing for data field
WHERE clause maybe acts as filter .. so logically filtering useful data make sense as unnecessary data gets ignored than comes Group By clause to view based on certain field .. later HAVING clause acts only on Aggregated columns temporarily created (for eg: SUM, AVG, MIN, MAX and COUNT) using SELECT clause mentioning Aggregated columns generally denoted using Aliasing
Thank you, ma'am, for the wonderful session. I have a doubt: as you explained for the previous question, don't we need the DISTINCT function to get unique salaries when finding the two highest salaries?
Actually there was a small typo, its top 2 salaries not the top 2 highest salaries. So here top 2 basically means order the salary in descending order and provide the 2 from the top.
At 19:35, there is a small typo, its top 2 salaries not the top 2 highest salaries. So, here top 2 basically means 1. order the salary in descending order and 2.provide the 2 from the top.
@@Aestheticdeeps correct for highest we need distinct. top 2 basically here is i have ordered all the salary in descending order and picking top 2 , top 2 highest means i have to pick the highest top 2 after ordering in desc order.
Hi Riti I love your videos - they’re always so informative and engaging! Just a quick suggestion: adding timestamps for different sections could make navigation easier for viewers. Keep up the great work!
Madam , there is one mistake in your video. The FULL OUTER JOIN is used to return all of the records that have values in either the left or right table. Whether it is same values or different it will return all. Please correct that
It would be LIMIT N-1, 1 as told in the video Reference articles : www.geeksforgeeks.org/find-nth-highest-salary-table/ www.sqlrevisited.com/2022/03/how-to-find-nth-highest-salary-in-sql.html#:~:text=Using%20LIMIT%20keyword%20(works%20in%20MySQL%20and%20PostgreSQL)&text=Without%20utilizing%20a%20subquery%2C%20you,and%20see%20how%20it%20works.
As promised part 2 : ruclips.net/video/pN0Hx9kz-mQ/видео.htmlsi=Q3OGgwvXPiEgjxxF
If you want part-2, please let me know in comments :))
@@Aman-r7b😂
Mam, can you please make a video on windows function as well.
Make a video on window functions too..
Need scenario based pdf sql server
If POSSIBLE part 3 also mam❤
nice explanation you actually covered more concept in minimum time era happy to watch sql series keep doing it. Thanks a lot from all folks.🎉❤
Post part 2 As soon as possible
We need videos on window functions and common table expressions (CTE). These will be very helpful. Additionally, we want to create more difficult questions in part 2 that are asked by top MNCs, as the current ones are too easy.
Hi Riti Kumari madam I hope you're doing well ,your explanations are easy to understand as well as easy to feed information into the brain ,is there any possibility to do some excel interview questions also no one is doing about Excel interview questions also it helps lot who are preparing for data field
Informative as Always . Thank you so much Riti didi.
Great, and informative, just mention tge levwl of difficulty of these videos
This is very helpful for any beginners, well explained and easy to understand 👍
Great collection Riti! this really helped revising for interview
THANK YOU SO MUCH ... I got this video that i stuck in sql . greatful for this miss riti.
Post part 2 ma'am; part 1 is absolutely lit and is very useful . Thank you for such quality content!!
Good Explanation waiting for Part Second 👍
It's so informative,please make more such videos
May I know ....what is Aggregate function?
Please make part -2 SQL interview questions answers ❤i am waiting for it...
impressive & informative Riti. Please post the part-2 as soon as possible
Good KT-Thanks @Ritikumari.. Part 2 Please
Thanks for sharing Mam and waiting for the part-2
Thanks for the Questions. Please make part 2
WHERE clause maybe acts as filter .. so logically filtering useful data make sense as unnecessary data gets ignored than comes Group By clause to view based on certain field .. later HAVING clause acts only on Aggregated columns temporarily created (for eg: SUM, AVG, MIN, MAX and COUNT) using SELECT clause mentioning Aggregated columns generally denoted using Aliasing
Please upload part 2 at the earliest ❤❤❤
very nice video mam thank you so much please upload more videos
Nice and Informative video Thank You Very Much
Easy to understand waiting fort part 2
Thank you, ma'am, for the wonderful session. I have a doubt: as you explained for the previous question, don't we need the DISTINCT function to get unique salaries when finding the two highest salaries?
Actually there was a small typo, its top 2 salaries not the top 2 highest salaries.
So here top 2 basically means order the salary in descending order and provide the 2 from the top.
PART 2 with some join questions as well please.
Explain about ACID properties and transactions and advanced concepts.
nice questions covered helpful
Please post part -2 SQL Video Thank You
Yes, we need second part
thank you soo much mam amazing explanation♥♥♥
really helpful content
Yes we want part 2 also
At 19:35, there is a small typo, its top 2 salaries not the top 2 highest salaries.
So, here top 2 basically means
1. order the salary in descending order and
2.provide the 2 from the top.
Yes for finding the top 2 highest salary i think DISTINCT should be used?
@@Aestheticdeeps correct for highest we need distinct.
top 2 basically here is i have ordered all the salary in descending order and picking top 2 , top 2 highest means i have to pick the highest top 2 after ordering in desc order.
Please share us part-2 also mam.
Yes, part 2 please🙏
PART 2 and PART 3 ALSO mam ❤
Post part 2 also plz...
Yes mam we want part-2
Great video,very Infomative
very very very useful content
Explain the concept of n-1,1 and what is the answer for that question?
Useful need part 2
Thank you didi
SQL part 2 and queries to the questions related with two tables...
Very helpful video
Nice video , thank you
Thank you
Yes we want
Please upload part 2
Yes please provide thanks madam for sharing
thanks ka! from TN!
Make bit harder questions. Other than videos are excellent
Can you also make videos for experienced candidates?
Part 2 as soon as possible
Awesome 🎉
Hi Riti
I love your videos - they’re always so informative and engaging!
Just a quick suggestion: adding timestamps for different sections could make navigation easier for viewers.
Keep up the great work!
Keep Growing Mam...
Mam abhi aap kon si company me placed ho and what your package per annum??
Need more SQL interview questions mam
U have a nice voice
nice explanied...
awesome video
Very nice video mam.
Yes
Mam its too helpful ... W mam in the chat
Post part2 as well mam
Waiting for part 2
Please part 2
Please share part 2 madam
😍your voice
waiting for part-2🙃
Post part 2 mam❤
Part-2 please
Need part-2
Need top dbms interview questions
Bring the Part-2 plsssssss
Informative
Really Nice
Pls upload part-2
really helpfull
Madam , there is one mistake in your video. The FULL OUTER JOIN is used to return all of the records that have values in either the left or right table. Whether it is same values or different it will return all. Please correct that
nice video
Part 2 pls
DBMS questions also didi
Ya mam regards.
Part2
Part 2
Need part 2
Part 2 upload fast
Plz snd pdf drive link
Plz check your LIMIT and OFFSET concepts
For nth highest salary it should be
SELECT DISTINCT Salary
FROM table_name
ORDER BY Salary DESC
LIMIT 1, n-1;
It would be LIMIT N-1, 1 as told in the video
Reference articles : www.geeksforgeeks.org/find-nth-highest-salary-table/
www.sqlrevisited.com/2022/03/how-to-find-nth-highest-salary-in-sql.html#:~:text=Using%20LIMIT%20keyword%20(works%20in%20MySQL%20and%20PostgreSQL)&text=Without%20utilizing%20a%20subquery%2C%20you,and%20see%20how%20it%20works.
Top 30 SQL questions for what? 3 LPA jobs?
Post part 2
Young Matthew Rodriguez Helen Martinez Scott
Gattiman bolthey
How can I contact you Mam
Yes, we need part 2