Hi, I was not able to find the best query for finding the nth highest salary of an employee, but with this video I found it very simple to remember, thanks for this video. Also, please proceed further with other SQL questions you mentioned at the last.
Hello. Thanks a lot for the videos. Cheers. Note: I guess there is a gaffe at 7:15: Indexes with more that one column are called "composite indexes", not "clustered indexes".
The way you teach is superb.. the concepts i wasn't able to grab after learning for days, you explain it so effectively that I understand it in a single watch.
You Guys are awesome. It's day by day helping me to achieve my goal. Seriously, this channel is a gem and I've recommended it to my friends as well. I have one request, please make a video on real time scenario java interview questions. Like techno - managerial or client rounds mostly which will ask questions on scenario based. You're hell of a life & time saver. Bless you guys!!
Thanks a ton🙂. This means a lot us. Yes we are about to create a video on real time scenerios that are asked in interviews. Thanks for the suggestion 👍👍
First of all thanks a ton on starting this SQL series. I am expecting to refer only your videos, to brush up these topics. Waiting impatiently for next video 😁 Please help me in implementing Spring Security with OAuth 2 and JWT. Any references having flow the way you explain, will be helpful...!
Nice approach, But what if there are same salary for 2 employees , 1, Ram , 12000 2, Aksha , 15000 3, Manish, 12000 4. Ritu , 10000 5, Rohit, 8000 Here third highest should be 10,000 ie 4th row
Thanks for the Video, For the query to find Nth highest salary, I believe LIMIT will not work in all the DB's. Could you please explain using TOP too and is there any other approach too for the same?
First of all thanks a ton on starting this SQL series. I'm expecting video on angular interview questions, Please try to do a video on angular interview questions
Hi, I was not able to find the best query for finding the duplicate records in a table, also to show how many times all the columns have been repeatedly stored separately , can you create a video in which there would be much advance questions? Also I randomly found your channel and it's very helpful, this time I am looking to switch the job and by god's grace I found your channel and videos are very helpful to me.
Great video! one correction though.. Clustered indexes are indexes whose order of the rows in the data pages corresponds to the order of the rows in the index.
Hi, This is the wrong statement "Indexes with more than one column are called Clustered indexes". It is the case of the "composite index.".You can have only one clustered index in one table, but you can have one clustered index on multiple columns, and that type of index is called a composite index.
Appreciate your work.. Can you please upload a video for apache shiro authorization using dB tables and spring boot ? It will be very helpful. There is no proper examples found in google
Hi, I was not able to find the best query for finding the nth highest salary of an employee, but with this video I found it very simple to remember, thanks for this video. Also, please proceed further with other SQL questions you mentioned at the last.
Thanks . Sure Vinay 🙂👍
Pls check out row number concept. We can also do with that approach.
Please upload further videos. It will increase the employment rate of India because your videos are gem.
Thanks a ton Sarthak 🤣🤣. Sure we will upload more videos 👍👍.
@@CodeDecode that cracked me up too 😂😂
A gem comment..
you are teaching in very good manner. loved your teaching style, keep uploading videos faslter ,it is helping a lot to me others
thankyou.....
Thanks for the nice words sagar
Hello. Thanks a lot for the videos. Cheers.
Note: I guess there is a gaffe at 7:15: Indexes with more that one column are called "composite indexes", not "clustered indexes".
The way you teach is superb.. the concepts i wasn't able to grab after learning for days, you explain it so effectively that I understand it in a single watch.
Thanks a ton Shubham. It means a lot 🙂👍🙏🙏
You Guys are awesome. It's day by day helping me to achieve my goal. Seriously, this channel is a gem and I've recommended it to my friends as well.
I have one request, please make a video on real time scenario java interview questions. Like techno - managerial or client rounds mostly which will ask questions on scenario based.
You're hell of a life & time saver. Bless you guys!!
Thanks a ton🙂. This means a lot us. Yes we are about to create a video on real time scenerios that are asked in interviews. Thanks for the suggestion 👍👍
Thank you for all hard work you put.
Please cover triggers, partition, stored procedure and functions.
sure bhavik we will try to cover it soon
First of all thanks a ton on starting this SQL series. I am expecting to refer only your videos, to brush up these topics. Waiting impatiently for next video 😁
Please help me in implementing Spring Security with OAuth 2 and JWT. Any references having flow the way you explain, will be helpful...!
These are very nice topics. Thanks for the suggestion👍🙂. We will upload these in security series 👍👍
Hi I loved this video sooooooooooooooo much!!!! Please please upload the second part as I've been waiting for this kinda stuff for a long time.
Sure, we will upload it soon. Thanks 🙂
Nice approach, But what if there are same salary for 2 employees ,
1, Ram , 12000
2, Aksha , 15000
3, Manish, 12000
4. Ritu , 10000
5, Rohit, 8000
Here third highest should be 10,000 ie 4th row
No, when ever u sort in descending order, no one expects that. Even if they does, u can use distinct. Right?
select * from employeee where salary =(select distinct salary from employee order by salary desc limit 0,1);
If we have same salary then we should use GROUP BY Sal . It will handle duplicate Sal conditions also.
Yes please continue this SQL series - really good. If possible do resume Microservices section - it's pending for more than 2 months 👍
Yes karthikeyan due to time crunch and festive season it is getting delayed we will surely upload it soon...
Nice video mam. Please add more such videos on SQL. Will be waiting for your videos.Thanks for your efforts.
Sure Chaitali 👍🙂
because of your channel , i am getting all interviews cleared.
Many many congratulations on clearing your interviews Kanhiya 🎉🎉🎉🎊🎊. You rock👍. Keep learning keep shining ⭐✨⭐✨ Man
Thanks for the Video, For the query to find Nth highest salary, I believe LIMIT will not work in all the DB's. Could you please explain using TOP too and is there any other approach too for the same?
Ok will give more such options in next video 👍👍
First of all thanks a ton on starting this SQL series. I'm expecting video on angular interview questions, Please try to do a video on angular interview questions
Sure we are planning to start front end iqs too 🙂👍
It was awesome explanation. Please do provide still more frequently asked sql questions.
Sure Jeevansai 👍. Will do that 👍🙂
Hi, I was not able to find the best query for finding the duplicate records in a table, also to show how many times all the columns have been repeatedly stored separately , can you create a video in which there would be much advance questions?
Also I randomly found your channel and it's very helpful, this time I am looking to switch the job and by god's grace I found your channel and videos are very helpful to me.
Thanks Rudra, yrs nice topics 👍will create video on this topic 🙂👍
Great video! one correction though.. Clustered indexes are indexes whose order of the rows in the data pages corresponds to the order of the rows in the index.
yes, plz mam make more videos on further topics of sql asap. It will be so helpful... and thanks..
Sure 🙂👍
You explain each and every concept so well.Thank you so much
Thanks ahmed
First I need to say thanks for such awesome videos in ur channel.Thanks a lot ..Please proceed to create more videos about SQL
Sure wr will do that👍🙂
Thanks for the great effort. Pls put videos covering the question mentioned in the last section of the video.
Sure 🙂👍
Please add more series on most asked SQL interview questions.
sure shiksha you'll see next part in this week only
It is very good video to check out our Knowledge after learning. Thanks to #CodeDecode #Thanks
you're welcome srujan
Thanks for providing such video this is real helping me lot in interview preparation. Please create video on NOSQL db like: Cassandra,MongoDB also.
Sure Manoj, we are planning to do that👍👍
Ma'am really appreciate your hardwork and efforts .. 👍
Please make more video regarding this topic ..
Sure Vaibhav, we are planning next part soon 👍🙂
Thanks for the video....Nice one, Yes please make a continuation of this topic.....
Sure we will upload more 👍👍. Thanks 🙂
wonderful video 😍..very easily understandable
Thanks shruthi
Amazing video to the point and various approaches to solve also 👍👍
Thanks Sachin
Yes we want more topics to cover...plss make a video...eagerly waiting.
Sure Saugata, we will do that 👍👍
Please upload few more videos on SQL. Eagerly waiting for this videos
Sure we will create it soon.....
Please cover remaining....you are the best teacher. 👌
Thanks Sunita. Sure we will do that 🙂👍
Your explanation is really good ❤❤
Thanks
Waiting for next video ... kindly upload more videos on SQL
Sure ravindra we will upload the next part soon
Truely you guys are producing an awesome content which help to crack interview easily.Till now did a great job and keep going ❤️❤️
Thanks a ton 🙂👍
super video ,could please create another video for other questions in sql
sure jona we will upload next video this week
Ur video’s are excellent very useful 100% Please upload more videos
Thanks 🙂🙂 , sure 👍👍
Please upload a videos for tuning of SQL queries.
Sure. It's a very useful topic. We will do that👍👍
Please add more of SQL queries for interview
Sure we will create more videos on this
Hi, This is the wrong statement "Indexes with more than one column are called Clustered indexes". It is the case of the "composite index.".You can have only one clustered index in one table, but you can have one clustered index on multiple columns, and that type of index is called a composite index.
I expected few more SQL questions in this video, but it covered only two. if you can add more in ur future videos.
sure we will add more
Plz make vedio on pl/sql stored procedure interview questions
Please do a video on tricky string interview questions
Sure 🙂👍
Please make more videos on sql interview questions Mam
Sure amit we will create it soon
Please create a video on some data structures questions
Sure Sushant 👍
Please upload more videos on SQL.
Sure shylashree we will upload it soon
pl cover more ql interview questions and upload a video will be useful for us
Yes it's in queue 🙂👍
Mam please Cover more questions on SQL
sure sudhanshu we will cover it soon
Appreciate your work..
Can you please upload a video for apache shiro authorization using dB tables and spring boot ?
It will be very helpful. There is no proper examples found in google
Sure 👍🙂
@@CodeDecode thank you
We more such fine tune and best practices in SQL
Sure Priyanka 👍
Can u do one video on ajax calls jdbc drivers using java client and serverside validations
Awesome question collection
Thanks Amit 👍🙂
Hi ,kindly cover other topics also and upload the videos very useful
sure laxmi we will cover it soon
Indexes are stored outside the table na?? Then how they can be deleted after dropping a table
Code decode is the best
Thanks Mohit🙂👍
Well explained.
Thanks
Well explained 👍👍
Thanks 🙏
keep up the great work!
Thanks
Part 2 or more videos from SQL
Sure 👍 we will do that🙂👍
which editor you are using
IDE for sql you mean?
mam create more videos on sql pleaseeee
Sure Swapnil 👍 wr will do today🙂
Tnx for the video
Love your voice ❤
thanks for the video.
🙂🙂👍👍
One correction-It is not possible to create an index on a view
For third highest salary
What if highest sal is get repeated?
You are awesome..
Thanks Naleen 🙂👍
What if there are duplicate salaries ?
Is this mysql?
Yes