Top 9 SQL queries for interview | SQL Tutorial

No video

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

Рет қаралды 636,590

Күн бұрын

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

Пікірлер: 391

@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 codeera3020@gmail.com

@yashmathur5609 Жыл бұрын

@@CodeEra2020 sure mam...

@riyasharma_ Жыл бұрын

Hey! Which company is it?

@yashmathur5609 Жыл бұрын

@@riyasharma_ it's a bank

@CodeEra2020 Жыл бұрын

@@yashmathur5609 please record if possible..

@Shankaryadav-pz3uj 2 жыл бұрын

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 2 жыл бұрын

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

@lakshitsharma5533 2 жыл бұрын

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

@Shankaryadav-pz3uj 2 жыл бұрын

@@lakshitsharma5533 yes bro

@lakshitsharma5533 2 жыл бұрын

@@Shankaryadav-pz3uj please tell

@Shankaryadav-pz3uj 2 жыл бұрын

@@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 👍

@prasoonrauniyar8968 3 жыл бұрын

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

@CodeEra2020 3 жыл бұрын

Thank you so much for watching..

@RaviPandey-ng8ub 2 ай бұрын

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

@p.nandakishorreddy2215 2 ай бұрын

did you completed your interview

@gollasaivenkatesh 3 жыл бұрын

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.

@anuragmohanty1301 Жыл бұрын

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

@amankhhan3801 4 жыл бұрын

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

@CodeEra2020 4 жыл бұрын

Thanks and welcome

@akashkumaryadav2288 3 жыл бұрын

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

@CodeEra2020 3 жыл бұрын

Thanks for watching

@tekbssync5727 3 жыл бұрын

yes absolutely correct

@ankushmahajan3303 4 жыл бұрын

Amazing energy level, Thanks for crisp and clear presentation

@CodeEra2020 4 жыл бұрын

So nice of you

@tharallaanil4115 3 жыл бұрын

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 3 жыл бұрын

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

@AbdulHadi-qq9hq 2 жыл бұрын

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

@suneelkumargoyal 3 жыл бұрын

Most important queries and simply explain.

@CodeEra2020 3 жыл бұрын

I am so glad that you like it..

@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?

@milar1786 4 ай бұрын

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!

@divsreviews2860 Жыл бұрын

Wow.. outstanding video.. Very Helpful for rivision

@CodeEra2020 Жыл бұрын

Thank you so much😊

@palakmahajan9999 3 жыл бұрын

Nice information 👌👍👍

@CodeEra2020 3 жыл бұрын

Thank you dear

@ajimsayyad7006 3 жыл бұрын

Nice information

@CodeEra2020 3 жыл бұрын

I am glad you liked it and keep watching

@purvibeautytips9855 4 жыл бұрын

Excellent 👌👌👌

@CodeEra2020 4 жыл бұрын

Thanks a lot

@aryanshinde1822 Жыл бұрын

Thank yoy mam very useful this queries and easy to learn

@CodeEra2020 Жыл бұрын

Most welcome.

@savantrada4278 2 жыл бұрын

thanks for this videos it is really helpful for me

@ShivamSingh-hk5pn 2 жыл бұрын

You are amazing ... Incredible support u are giving

@aakashjay87 4 жыл бұрын

your explanation is waaaoooo....

@sarojchourasia9682 3 жыл бұрын

very nice video, thanks

@CodeEra2020 3 жыл бұрын

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

@aditiiawasthi6256 3 жыл бұрын

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

@CodeEra2020 3 жыл бұрын

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

@rajmahajan8518 4 жыл бұрын

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

@CodeEra2020 4 жыл бұрын

I'm so glad! and keep watching for more

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

@shahinasd5897 3 жыл бұрын

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

@CodeEra2020 3 жыл бұрын

You are welcome...

@prasadphatak1503 3 ай бұрын

This is actually good, learnt some good things here.

@ashwinkoli6531 3 жыл бұрын

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

@CodeEra2020 3 жыл бұрын

I am so glad you like the video

@alokranjan168 3 жыл бұрын

1.ans Select salary from employeeinfo Order by salary desc Limit 3,offset 2 ; It's right ma'am?

@shwetabadgujar1054 4 жыл бұрын

Good one👍

@CodeEra2020 4 жыл бұрын

Thanks ✌️

@vallabhmahajan6423 4 жыл бұрын

Good👍

@CodeEra2020 4 жыл бұрын

Thanks for the visit

@adarshdwivedi5395 3 жыл бұрын

Such a amazing vedio..

@CodeEra2020 3 жыл бұрын

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

@adarshdwivedi5395 3 жыл бұрын

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

@vishalchauhan9832 3 жыл бұрын

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

@CodeEra2020 3 жыл бұрын

My pleasure 😊 Thank you for watching.

@vishalchauhan9832 3 жыл бұрын

@@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 😁😁

@smileuntilyoudie5127 2 ай бұрын

Very Nice and helpfull questions

@piyushsrivastava5545 3 жыл бұрын

In your nth highest query, you might get error. Count is an aggregate function which needs group by and having clause . Please correct it.

@nakulanand2725 2 жыл бұрын

Thanks for this useful content.

@anujasule1485 3 жыл бұрын

thanks..great video

@CodeEra2020 3 жыл бұрын

Glad you liked it!

@saiKiran-mv4se 3 жыл бұрын

And beautiful questions

@CodeEra2020 3 жыл бұрын

Thank you

@kapilbhat696 3 жыл бұрын

Thanks for the video I learned a lot from this video

@CodeEra2020 3 жыл бұрын

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

@RajeshKumar-sz1mq 2 жыл бұрын

1st question answer by using window function spark.sql("select salary from (select salary,dense_rank() over(order by salary desc) as rank from employee group by salary ) where rank=3 ").show(10) +------+ |salary| +------+ | 13000| +------+

@janabodu3392 2 жыл бұрын

Crystal clear..Good job

@CodeEra2020 2 жыл бұрын

Thank you so much

@gauravghosh8002 3 жыл бұрын

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

@CodeEra2020 3 жыл бұрын

You are most welcome..

@YogeshSharma-um3ov 3 жыл бұрын

I think limit function is not there in t-sql. I think we have to use rownumber() in T-sql to get 3rd highest salary.

@balavenugopal3269 2 жыл бұрын

Dens rank

@unnatijaswani4832 2 жыл бұрын

@@balavenugopal3269 why? row number is also fine

@funandfood_hyderabad Ай бұрын

Thank you very very much 🙏🙏🙏🙏🙏🙏

@jordanabhishek4409 2 жыл бұрын

Thanku ma'am... Checkout this video one night before of my cognizant interview.... And maximum que were ask same as mentioned in video...

@ankushmahajan3303 4 жыл бұрын

This video is all I need, thanks for sharing!

@CodeEra2020 4 жыл бұрын

Glad it was helpful!

@sethsanwariyajewellers725 3 жыл бұрын

Very helpful 👍👍 please make more videos on SQL

@CodeEra2020 3 жыл бұрын

Sure I will

@prashanttripathi3534 2 жыл бұрын

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

@CodeEra2020 2 жыл бұрын

Glad you like the video Keep watching

@technaseeb7604 11 ай бұрын

Your first question is wrong because if 3 employee of top have save salary it print the same value so for it's we use group by function So the answer will be Select salary from employee_info group by salary order by salary desc limit 2,1; I hope it will help you

@AmanKumar-uf1nf 3 жыл бұрын

Thanks

@CodeEra2020 3 жыл бұрын

glad it helped

@shubhamagarwal2998 3 жыл бұрын

👌👌👌👌👌 crisp and helpful

@CodeEra2020 3 жыл бұрын

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

@shubhamagarwal2998 3 жыл бұрын

@@CodeEra2020 keep shining ✨✨✨

@prajaktapuri8261 4 жыл бұрын

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

@jayganeshpandey 2 жыл бұрын

Nic

@CodeEra2020 2 жыл бұрын

Thank you.

@SaiRam-cl6ih 2 жыл бұрын

Thank you very much ma'am

@sandhyavelmani3790 3 жыл бұрын

Quite helpful queries for understanding, Thank you 👍

@CodeEra2020 3 жыл бұрын

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

@niveditanandy2320 3 жыл бұрын

good one.

@CodeEra2020 3 жыл бұрын

Thank you so much

@angelthedecentgirl7181 2 жыл бұрын

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

@CodeEra2020 2 жыл бұрын

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

@madhukardwivedi1950 2 жыл бұрын

Very helpful....

@CodeEra2020 2 жыл бұрын

Glad you think so!

@surajmaity6194 2 жыл бұрын

GOOD

@indrajeetbadgujar614 4 жыл бұрын

Good one, keep it up

@CodeEra2020 4 жыл бұрын

Thank you, I will

@saiKiran-mv4se 3 жыл бұрын

Very good lovely

@CodeEra2020 3 жыл бұрын

Thanks a lot

@pravinkedar96 2 жыл бұрын

Excellent lecture

@CodeEra2020 2 жыл бұрын

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

@vivekwagh6668 3 жыл бұрын

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

@CodeEra2020 3 жыл бұрын

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

@vishnureddy3318 2 жыл бұрын

Simply exceptional ❤️

@CodeEra2020 2 жыл бұрын

Thank you so much.

@umeAsh393 3 жыл бұрын

Very informative . Thank you 🙏

@CodeEra2020 3 жыл бұрын

Happy to help you.. Thank you for watching

@tekbssync5727 3 жыл бұрын

best video😅 for revise imp sql Qs. .........btw your no. of likes are more than no. of subsribers

@CodeEra2020 3 жыл бұрын

Thank you so much for watching

@aj9706 2 жыл бұрын

Amazing

@CodeEra2020 2 жыл бұрын

Thank you! Keep wathing

@aastha4708 3 жыл бұрын

Thanks for sharing...

@CodeEra2020 3 жыл бұрын

Glad You like it...

@prakashshukla3558 3 жыл бұрын

Good Video

@CodeEra2020 3 жыл бұрын

Thank you so much

@decodingtimer 3 жыл бұрын

Thanks for explaining 👍👍

@CodeEra2020 3 жыл бұрын

most welcome

@tapasbiswal6693 3 жыл бұрын

Hello, just want to say that, please do it practically, any way I have enjoyed..

@CodeEra2020 3 жыл бұрын

I will try to make it practically and thank you so much for watching

@kimleng539 4 ай бұрын

❤ I am student Data Science need your videos.

@juno7893 3 жыл бұрын

Nice 👏🏻👏🏻👏🏻

@CodeEra2020 3 жыл бұрын

Thanks...

@dattatrayjadhav3758 Жыл бұрын

Too helpful

@CodeEra2020 Жыл бұрын

Thank you 😊

@KK-xw5fn 3 жыл бұрын

Much useful if complete video in english this will be very helpful for everyone....

@CodeEra2020 3 жыл бұрын

I will make sure to make complete video in english..

@kirantodkar5034 2 жыл бұрын

Very Nice Mam, Thanks....

@harshkumargupta8538 2 ай бұрын

quality video.

@niranjannahak 3 жыл бұрын

For the Last Record Fetch SELECT * FROM table_name ORDER BY Column_name DESC LIMIT 1;

@chamankumar3047 5 ай бұрын

Helpful but use only Hindi. Language mam but really useful 👏🏻

@nileshnandeshwar4422 3 жыл бұрын

Informatie videos, please make an another videos on IT industries interview questions ...Thanks , keep going

@CodeEra2020 3 жыл бұрын

Sure I will. Thank you for watching.

@bhawdeepkumawat2868 4 жыл бұрын

Thanks for helping us interview preparation

@CodeEra2020 4 жыл бұрын

It's my pleasure

@adityaranjan9662 Жыл бұрын

Amazing Session , really helpful....

@chubbygirl1 2 жыл бұрын

beautiful vedio..such informative.

@shyamjigupta9062 Жыл бұрын

Thank u mam .

@CodeEra2020 Жыл бұрын

Welcome😊

@shubhambhawsar8762 4 жыл бұрын

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

@CodeEra2020 4 жыл бұрын

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

@debashisjena6836 3 жыл бұрын

Please make some more video related sql amd plsql

@CodeEra2020 3 жыл бұрын

Sure ,soon I will upload a new video on SQL Or you can also suggest the topic...

@Londonpounds723 3 жыл бұрын

Wl u pls tel us in English. So many are listening ur class so pls make nxt video in english

@CodeEra2020 3 жыл бұрын

I will try my best

@rdhgaminghub5099 3 жыл бұрын

very helpful...

@siyamahajan6079 4 жыл бұрын

this is the best one....

@a.k2045 2 жыл бұрын

Tnx a lot sister...😊

@dipakansagra671 Жыл бұрын

This lesson help me lots! I couldn't find PDF file for download table

@luckychowdary5699 3 жыл бұрын

Tnq so much for this imp questions and this questios is so much helpful and my suggestion is please provide some more imp questions please, it's my humble request

@CodeEra2020 3 жыл бұрын

Thank you so much for watching and soon I am going to make its second part...

@luckychowdary5699 3 жыл бұрын

@@CodeEra2020 make it fast sir please

@jobtechandgovt.examprepara3974 2 жыл бұрын

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

@CodeEra2020 2 жыл бұрын

Thank you so much. For highest salary you can watch this video kzfaq.info/get/bejne/iMh7jdCAnceRqZc.html

@akashbasak1759 2 ай бұрын

in the first question if there are duplicates of highest salary and if we put a limit, then after sorting how can the third row will be having the third highest salary? my approach using a distinct keyword select * from employeeinfo where salary=(select * from (select distinct(salary) from employeeinfo) as e1 order by age desc limit 2,1); correct me if I am wrong Thank You