Top 9 SQL queries for interview | SQL Tutorial | Interview Question

#mysql #oracle #dbms #query #top #sqlserver #database
In this video we will see #Top 9 #SQL query Which are very important for the #PlacementPreparation
👉The TOP 9 SQL query are-
✅Find the third-highest salary from the EmployeeInfo table.
✅Find the Nth highest salary from the table without using TOP/limit keyword.
✅Find duplicate rows in a table.
✅Calculate the even and odd records from a table.
✅Display the first and the last record from the EmployeeInfo table.
✅How do you copy all rows of a table using SQL query?
✅Retrieve the list of employees working in the same department.
✅Retrieve the last 3 records from the EmployeeInfo table.
✅Fetch details of employees whose EmpLname ends with an alphabet ‘A’ and contains five alphabets.
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
Please like 👍, subscribe and share......
Follow us on Instagram -
/ codeera_
🙏Thank you so much for watching and your support..
⭐Encapsulation in java-
• Java tutorial|#Encapsu...
⭐DBMS vs RDMS
• DBMS vs RDBMS | What i...
⭐Keys in DBMS
• Types of Keys in DBMS ...
⭐Normalization in DBMS-
• Normalization and its ...
⭐class and object in java-
• What is Class and Obje...
⭐Types of key in DBMS-
• Types of Keys in DBMS ...
⭐how to install java-
• How to Install JAVA JD...
⭐Introduction of java:-
• Introduction to Java i...
⭐Features of java:-
• Features of java Part 2
⭐JVM JRE JDK:-
• JDK JRE JVM in Java Pa...
⭐MySQL Database -
• How to Create Database...
⭐JVM architecture-
• JVM architecture in Java
⭐Difference between oop and pop
• Difference between OOP...

[@yashmathur5609]

Thank you mam, I got 6LPA just because of your all videos.. Being a mechanical engineer i never thought i will get 6lpa as a fresher but all this can happened because of you!
Thank you once again mam

[@CodeEra2020]

Many many congratulations party🎉🎉🎉.
Would you like to share your interview experience with us? Please Share it on [e-mail]

[@yashmathur5609]

@@CodeEra2020 sure mam...

[@riyasharma_]

Hey! Which company is it?

[@yashmathur5609]

@@riyasharma_ it's a bank

[@CodeEra2020]

@@yashmathur5609 please record if possible..

[@AbdulHadi-qq9hq]

Thank you very much Di for very to-the-point explanation of basic SQL queries!

[@Shankaryadav-pz3uj]

Thank a lot ma'am your video is very helpful I can't express in word I have selected conduent company 4.2 LPa🙏🙏 again'thank your

[@CodeEra2020]

I am so happy for you. Best wishes for your bright future. Thank you for watching.

[@lakshitsharma5533]

Hi, cogratulation for that offer. Can you share the interview process?

[@Shankaryadav-pz3uj]

@@lakshitsharma5533 yes bro

[@lakshitsharma5533]

@@Shankaryadav-pz3uj please tell

[@Shankaryadav-pz3uj]

@@lakshitsharma5533 There are basically two type of company 1 service based company 2 product based company suppose if you want to crack a interview of service based company 1 you have good knowledge of any language Just like C++ python Java etc and also knowledge of SQL if you want to crack a interview of product based company you have good knowledge of any programing language Just like C++ Java python etc and Data structures algorithm also SQL 👍

[@ShivamSingh-hk5pn]

You are amazing ... Incredible support u are giving

[@chubbygirl1]

beautiful vedio..such informative.

[@prasoonrauniyar8968]

This video helped me as a quick refreshment of SQL, appreciate your hard work.

[@CodeEra2020]

Thank you so much for watching..

[@nakulanand2725]

Thanks for this useful content.

[@anuragmohanty1301]

Awesome, Excellent, Nothing is better than this... Ma'am

[@RaviPandey-ng8ub]

I have my TCS nqt interview in the upcoming week. This video helps me a lot

[@p.nandakishorreddy2215]

did you completed your interview

[@adityaranjan9662]

Amazing Session , really helpful....

[@smileuntilyoudie5127]

Very Nice and helpfull questions

[@amankhhan3801]

Very helpful video , well explained and very good collection of interview questions , Thankyou 🙏

[@CodeEra2020]

Thanks and welcome

[@prajaktapuri8261]

Thank you so much mam for this helpful video🙏🙏❤️❤️❤️

[@ankushmahajan3303]

Amazing energy level, Thanks for crisp and clear presentation

[@CodeEra2020]

So nice of you

[@savantrada4278]

thanks for this videos it is really helpful for me

[@San_Jan_]

Too good for interview 👏👏

[@akashverma1640]

Quick questions. Thanks.💓

[@rdhgaminghub5099]

very helpful...

[@01kumarr]

Thanks really informative 👍

[@shwetajha5356]

Good explanation 👍

[@ankushmahajan3303]

This video is all I need, thanks for sharing!

[@CodeEra2020]

Glad it was helpful!

[@suneelkumargoyal]

Most important queries and simply explain.

[@CodeEra2020]

I am so glad that you like it..

[@sachinkabburkar3589]

Thanks for Information

[@prajavjha3780]

Amazing...❤️❤️

[@AbhishekPandey-vu8qi]

very nice explanation thanks

[@digambarbhandare4485]

Very nice explanation

[@divsreviews2860]

Wow.. outstanding video.. Very Helpful for rivision

[@CodeEra2020]

Thank you so much😊

[@gollasaivenkatesh]

for nth highest salary problem
SELECT DISTINCT Salary FROM Employee e1 WHERE (SELECT COUNT(DISTINCT Salary) FROM Employee e2 WHERE e2.Salary > e1.Salary) = N - 1 will be the correct one since there can be multiple employees with highest salary.

[@milar1786]

Great presentation.
Very clear explanation and target precision poin very simple way any one can understand even a person has no previous query background.
Thank you Ms Erra!

[@kirantodkar5034]

Very Nice Mam, Thanks....

[@prasadphatak1503]

This is actually good, learnt some good things here.

[@akashkumaryadav2288]

These are the most important questions for interviews and generally asked by the interviewer frequently

[@CodeEra2020]

Thanks for watching

[@tekbssync5727]

yes absolutely correct

[@harshkumargupta8538]

quality video.

[@palakmahajan9999]

Nice information 👌👍👍

[@CodeEra2020]

Thank you dear

[@siyamahajan6079]

this is the best one....

[@aditiiawasthi6256]

Very helpful and nice video...thankyou for sharing your knowledge..really appreciate your efforts 🙏🙏

[@CodeEra2020]

I am so happy to hear that... Thank you so much and keep watching

[@shubhambhawsar8762]

Thanku so much for providing this information and your every video comes with something new in basic concepts. Good job, keep it up👍😊

[@CodeEra2020]

So nice of you and i am so glad you like it

[@aakashjay87]

your explanation is waaaoooo....

[@purvibeautytips9855]

Excellent 👌👌👌

[@CodeEra2020]

Thanks a lot

[@gauravghosh8002]

Thank you so much Ma'am for your detailed information. This helped me a lot to brushup

[@CodeEra2020]

You are most welcome..

[@sandhyavelmani3790]

Quite helpful queries for understanding, Thank you 👍

[@CodeEra2020]

So glad it helped you and thank you so much for watching...

[@divyadubey6679]

Thank u so much.. God bless u...

[@vivekwagh6668]

loved the video would like to have 2nd part for it

[@CodeEra2020]

Happy to hear that you liked the video... Surely I Will make second part and you can also share topic or sql quires that you wanna discuss...

[@ashwinkoli6531]

Thank you for this vid it's better understanding for us how to learn in simply way to SQL

[@CodeEra2020]

I am so glad you like the video

[@indrajeetbadgujar614]

Good one, keep it up

[@CodeEra2020]

Thank you, I will

[@saiKiran-mv4se]

And beautiful questions

[@CodeEra2020]

Thank you

[@ajimsayyad7006]

Nice information

[@CodeEra2020]

I am glad you liked it and keep watching

[@shahinasd5897]

Thanks for explains easily...i understand these all queries..😊

[@CodeEra2020]

You are welcome...

[@sarojchourasia9682]

very nice video, thanks

[@CodeEra2020]

thank you so much for watch ..... glad it helped

[@SaiRam-cl6ih]

Thank you very much ma'am

[@shwetabadgujar1054]

Good one👍

[@CodeEra2020]

Thanks ✌️

[@Sohelkhans50]

While getting employees working in same department we can use groupby instead of using alias for two tables. Whenever u use alias for a table it creates a copy of that table in RAM, which is highly inefficient if u have large table with thousands of rows.

[@SunilKumar0261]

totally agree

[@SunilKumar0261]

totally agree

[@laxmiprasanna5984]

But it gives us only one value when we use group by .How about others?

[@decodingtimer]

Thanks for explaining 👍👍

[@CodeEra2020]

most welcome

[@aastha4708]

Thanks for sharing...

[@CodeEra2020]

Glad You like it...

[@navvinram6422]

Great

[@juno7893]

Nice 👏🏻👏🏻👏🏻

[@CodeEra2020]

Thanks...

[@prashanttripathi3534]

This videos was really very gud,just revised my whole concept by practicing side by side.
Thank you so much,

[@CodeEra2020]

Glad you like the video
Keep watching

[@tshende02]

Thanks a lot ❤️

[@bhawdeepkumawat2868]

Thanks for helping us interview preparation

[@CodeEra2020]

It's my pleasure

[@anujasule1485]

thanks..great video

[@CodeEra2020]

Glad you liked it!

[@vishnureddy3318]

Simply exceptional ❤️

[@CodeEra2020]

Thank you so much.

[@tharallaanil4115]

This video is helpful to SQL beginner and also advance level people to useful and interview purposes all people to required . We are expecting more videos from your channel, SQL based and you know different type language interview questions provide me and also you voice nice

[@CodeEra2020]

I am so glad that you like the video .Soon I will upload its second part and thank you so much for watching

[@umeAsh393]

Very informative . Thank you 🙏

[@CodeEra2020]

Happy to help you.. Thank you for watching

[@vishalchauhan9832]

Such a beautiful and important content.Thank You so much mam

[@CodeEra2020]

My pleasure 😊
Thank you for watching.

[@vishalchauhan9832]

@@CodeEra2020 once in a interview I was asked to calculate 2nd or 5 th highest . At that time I was not that much aware. Then I told that we can sort them firstly in Descending order after that we can fetch 5th one. But I was not aware how I can fetch 5th record because I was not aware about limit clause. Then I watch your video.. After watching it I feel confident. But in later interview the interviwer asked me only about DML DDL commands 😁😁

[@sudiptachakraborty745]

Great work 😎

[@CodeEra2020]

Thank you so much

[@adarshdwivedi5395]

Such a amazing vedio..

[@CodeEra2020]

Thank you so much... So glad that it helped you..

[@adarshdwivedi5395]

If u have list of imp sql query could u pla send me...right now beco i am preparing for interview

[@surajmaity6194]

GOOD

[@angelthedecentgirl7181]

Best video and explanation ever, Thank You so much ma'am.

[@CodeEra2020]

Glad you liked the video. Thank you so much for watching.

[@kapilbhat696]

Thanks for the video I learned a lot from this video

[@CodeEra2020]

So glad to know that the video helps you..
Thank you for watching

[@janabodu3392]

Crystal clear..Good job

[@CodeEra2020]

Thank you so much

[@prachipathak5963]

Good 👍

[@CodeEra2020]

Thanks for the visit

[@yashmathur5609]

thanks a lot

[@aryanshinde1822]

Thank yoy mam very useful this queries and easy to learn

[@CodeEra2020]

Most welcome.

[@pravinkedar96]

Excellent lecture

[@CodeEra2020]

Thank you so much.. So glad that you like the video

[@datazerohero]

Nice video! SQL interviews can be tricky. I've recently started a channel where I share some SQL interview questions and solutions. I'd love your thoughts and suggestions. Keep up the great work

[@rajmahajan8518]

The video is soo good I learned some new things in sql Thanks for making these video😊 It is soo Good

[@CodeEra2020]

I'm so glad! and keep watching for more

[@sethsanwariyajewellers725]

Very helpful 👍👍 please make more videos on SQL

[@CodeEra2020]

Sure I will

[@a.k2045]

Tnx a lot sister...😊

[@hemantvardani1436]

Thanks!!

[@niharika3608]

Very good refresher :)

[@CodeEra2020]

Glad you like it

[@niveditanandy2320]

good one.

[@CodeEra2020]

Thank you so much

[@madhukardwivedi1950]

Very helpful....

[@CodeEra2020]

Glad you think so!

[@saiKiran-mv4se]

Very good lovely

[@CodeEra2020]

Thanks a lot

[@aj9706]

Amazing

[@CodeEra2020]

Thank you! Keep wathing

[@omkarkhilari6207]

Great Video Helped alot!

[@CodeEra2020]

Glad to hear! Thank you so much for watching

[@kimleng539]

❤ I am student Data Science need your videos.

[@prakashshukla3558]

Good Video

[@CodeEra2020]

Thank you so much

[@dattatrayjadhav3758]

Too helpful

[@CodeEra2020]

Thank you 😊

[@unnatijaswani4832]

nice 😍😍😍😍😍😍

[@CodeEra2020]

Thank you so much.

[@dattatrayjadhav3758]

I have tried all the query and it's too helping me thank you so much sister❤

[@CodeEra2020]

You are welcome... Thank you so much for watching.

[@aptrends3257]

Thanku very much mam

[@CodeEra2020]

You are welcome 😊

[@stereolyrics2386]

Really helpful and very well explained. Thanks a lot

[@CodeEra2020]

Glad it was helpful!

[@shubhamagarwal2998]

👌👌👌👌👌 crisp and helpful

[@CodeEra2020]

Glad to know that you like it.Thank you so much for watching

[@shubhamagarwal2998]

@@CodeEra2020 keep shining ✨✨✨

[@TheVijaynegi]

first I thought I can solve them easily but then I realised the complexity level ...thanks for sharing ..now I came to know from where interviewer use to collect question :)

[@CodeEra2020]

I am so glad that it helped you thank you so much for watching...

[@shyamjigupta9062]

Thank u mam .

[@CodeEra2020]

Welcome😊

[@AmanKumar-uf1nf]

Thanks

[@CodeEra2020]

glad it helped

[@jayganeshpandey]

Nic

[@CodeEra2020]

Thank you.

[@jobtechandgovt.examprepara3974]

Please tell other ways of finding highest salary..btw all your videos are very helpful..keep growing..new subscriber in your list..🙂

[@CodeEra2020]

Thank you so much.
For highest salary you can watch this video ua-cam.com/video/RbKZmO8a-yc/v-deo.html

[@prakashjagtap865]

Thanq mam

[@CodeEra2020]

You are welcome... Keep watching

[@terryterry3733]

Super
Mam

[@CodeEra2020]

Thank you so much for watching.