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.
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.
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 👍👍
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
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.
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...!
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..
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".
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
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 🙂👍🙏🙏
Nice video mam. Please add more such videos on SQL. Will be waiting for your videos.Thanks for your efforts.
Sure Chaitali 👍🙂
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 🙂
Your explanation is really good ❤❤
Thanks
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
wonderful video 😍..very easily understandable
Thanks shruthi
Amazing video to the point and various approaches to solve also 👍👍
Thanks Sachin
It is very good video to check out our Knowledge after learning. Thanks to #CodeDecode #Thanks
you're welcome srujan
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 👍👍
Thanks for the video....Nice one, Yes please make a continuation of this topic.....
Sure we will upload more 👍👍. Thanks 🙂
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...
It was awesome explanation. Please do provide still more frequently asked sql questions.
Sure Jeevansai 👍. Will do that 👍🙂
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
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👍🙂
yes, plz mam make more videos on further topics of sql asap. It will be so helpful... and thanks..
Sure 🙂👍
Please cover remaining....you are the best teacher. 👌
Thanks Sunita. Sure we will do that 🙂👍
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 🙂👍
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 great effort. Pls put videos covering the question mentioned in the last section of the video.
Sure 🙂👍
You explain each and every concept so well.Thank you so much
Thanks ahmed
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 🙂👍
Yes we want more topics to cover...plss make a video...eagerly waiting.
Sure Saugata, we will do that 👍👍
Ur video’s are excellent very useful 100% Please upload more videos
Thanks 🙂🙂 , sure 👍👍
Waiting for next video ... kindly upload more videos on SQL
Sure ravindra we will upload the next part soon
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👍👍
keep up the great work!
Thanks
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 👍👍
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);
Well explained 👍👍
Thanks 🙏
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.
Please add more series on most asked SQL interview questions.
sure shiksha you'll see next part in this week only
Please upload few more videos on SQL. Eagerly waiting for this videos
Sure we will create it soon.....
super video ,could please create another video for other questions in sql
sure jona we will upload next video this week
Well explained.
Thanks
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 🙂👍
Love your voice ❤
Code decode is the best
Thanks Mohit🙂👍
Please upload a videos for tuning of SQL queries.
Sure. It's a very useful topic. We will do that👍👍
Awesome question collection
Thanks Amit 👍🙂
thanks for the video.
🙂🙂👍👍
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 👍👍
Please add more of SQL queries for interview
Sure we will create more videos on this
Please upload more videos on SQL.
Sure shylashree we will upload it soon
We more such fine tune and best practices in SQL
Sure Priyanka 👍
You are awesome..
Thanks Naleen 🙂👍
Plz make vedio on pl/sql stored procedure interview questions
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
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 👍
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.
pl cover more ql interview questions and upload a video will be useful for us
Yes it's in queue 🙂👍
Indexes are stored outside the table na?? Then how they can be deleted after dropping a table
Tnx for the video
Mam please Cover more questions on SQL
sure sudhanshu we will cover it soon
which editor you are using
IDE for sql you mean?
Hi ,kindly cover other topics also and upload the videos very useful
sure laxmi we will cover it soon
Can u do one video on ajax calls jdbc drivers using java client and serverside validations
Part 2 or more videos from SQL
Sure 👍 we will do that🙂👍
mam create more videos on sql pleaseeee
Sure Swapnil 👍 wr will do today🙂
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
For third highest salary
What if highest sal is get repeated?
One correction-It is not possible to create an index on a view
What if there are duplicate salaries ?
Is this mysql?
Yes