Most Asked SQL interview questions and answers for Java Developers with examples | Code Decode

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

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

Yes we want more topics to cover...plss make a video...eagerly waiting.

Mam please Cover more questions on SQL

Please upload a videos for tuning of SQL queries.

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!!

Hi ,kindly cover other topics also and upload the videos very useful

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. <3 <3

I expected few more SQL questions in this video, but it covered only two. if you can add more in ur future videos.

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.

Truely you guys are producing an awesome content which help to crack interview easily.Till now did a great job and keep going ❤️❤️

Is this mysql?

Please upload more videos on SQL.

Ma'am really appreciate your hardwork and efforts .. 👍
Please make more video regarding this topic ..

Please upload few more videos on SQL. Eagerly waiting for this videos

you are teaching in very good manner. loved your teaching style, keep uploading videos faslter ,it is helping a lot to me others
thankyou.....

Please cover remaining....you are the best teacher. 👌

Waiting for next video ... kindly upload more videos on SQL

which editor you are using

Please make more videos on sql interview questions Mam

pl cover more ql interview questions and upload a video will be useful for us

Please add more series on most asked SQL interview questions.

super video ,could please create another video for other questions in sql

One correction-It is not possible to create an index on a view

You are awesome..

What if there are duplicate salaries ?

Please add more of SQL queries for interview

Code decode is the best

You explain each and every concept so well.Thank you so much

wonderful video 😍..very easily understandable

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.

Thank you for all hard work you put.
Please cover triggers, partition, stored procedure and functions.

Plz make vedio on pl/sql stored procedure interview questions

Amazing video to the point and various approaches to solve also 👍👍

Ur video’s are excellent very useful 100% Please upload more videos

keep up the great work!

because of your channel , i am getting all interviews cleared.

Well explained.

For third highest salary
What if highest sal is get repeated?

thanks for the video.

Indexes are stored outside the table na?? Then how they can be deleted after dropping a table

We more such fine tune and best practices in SQL

If we have same salary then we should use GROUP BY Sal . It will handle duplicate Sal conditions also.

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.

Your explanation is really good ❤❤

Love your voice ❤

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.