PART 2 : Top 9 SQL queries for interview | SQL Tutorial

PART 2 : Top 9 SQL queries for interview | SQL Tutorial | Advance Interview Question

Рет қаралды 91,878

Күн бұрын

In this video we will see advanced #Top 9 #SQL query Which are very important for the #PlacementPreparation
✔Link for SQL file-
drive.google.com/file/d/1zra8...
✔Link for query PDF-
drive.google.com/file/d/1D4hn...
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Create MySQL Database and Table -
• How to Create Database...
TCS NQT Sample Paper:
👉drive.google.com/file/d/1FXOW...
TCS NQT Sample Paper solutions:
• TCS NQT 2021 Complete ...
TCS NQT 2021 Complete Registration Process | Exam Pattern
👉 • TCS NQT 2021 Complete ...
✔Difference between oop and pop :
👉 • Difference between OOP...
💥Access Modifier in Java-Public,Protected,Private and Default
👉 • Access Modifier in Jav...
💥Constructor in Java
👉 • Constructor In Java |T...
💥Part 3 of 3 :Database Connectivity
👉 • How to Fetch Data from...
💥Part 2 of 3 :Database Connectivity
👉 • How To Insert Data In ...
💥Part 1 of 3 :Database Connectivity
👉 • Database Connectivity ...
⭐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...
⭐JVM architecture-
• JVM architecture in Java
#mysql #oracle #dbms #query #top #sqlserver #database

Пікірлер: 98

@CodeEra2020 2 жыл бұрын

Now Everyone can Access those PDF and SQL file. If not then please drop a comment.

@gauravnagpal172 2 жыл бұрын

Perfectly Explained 💯

@priyansha2323 2 жыл бұрын

Very nice video for quick revision. thank you

@MrRanjitsihag 2 жыл бұрын

Video bahut badiya 👌👌👌👍

@angelthedecentgirl7181 2 жыл бұрын

Amazing video. Thank You mam

@reshmababugulbahadur6556 3 жыл бұрын

Yes pls make more sql queries

@kartikeychaturvedi4429 3 жыл бұрын

Great job! It's very helpful

@CodeEra2020 3 жыл бұрын

So glad it helped you... Keep watching

@exclusiveglobaleducation2658 Жыл бұрын

thanks for important questions❤

@jaymahajan3871 3 жыл бұрын

Good 👍👍

@sachinkabburkar3589 2 жыл бұрын

Thanks for Information

@akshaypawar7449 7 ай бұрын

Yes I have completed this video

@shaziasamreen8584 2 жыл бұрын

Very very very helpful for revision of SQL.Thanks for the good explanation.And one thing is you didi not add this in SQL playlist.Kindly add it.

@CodeEra2020 2 жыл бұрын

Yes, you are right . And I just add it to SQL playlist .Thank you for watching.

@anjalisaini2164 2 жыл бұрын

thanks maam .. this video is very helpful

@CodeEra2020 2 жыл бұрын

You are welcome.. Thank you for watching

@nainarajput6426 3 жыл бұрын

Thank you for this video..

@CodeEra2020 3 жыл бұрын

You are welcome..

@palakmahajan9999 3 жыл бұрын

Very nice explain 🤗👌👌

@CodeEra2020 3 жыл бұрын

Thank you 😀

@hemantkumar1072 Жыл бұрын

great

@nakulanand2725 2 жыл бұрын

Thanks for this helpful video

@CodeEra2020 2 жыл бұрын

So glad that our video helped you. Thank you for watching.

@sandeshkhade5513 Жыл бұрын

THANKS FOR GIVING MOST IMP QUERY

@CodeEra2020 Жыл бұрын

You are Welcome

@terryterry3733 2 жыл бұрын

thanks for Link for query PDF-

@CodeEra2020 2 жыл бұрын

Glad to help... You are wel come.

@ramagirisurendra4144 Жыл бұрын

can u explain difference between oracle nd my sql dbs.

@sachinupreti7159 Жыл бұрын

at 5:51 can't we use having after group by instead of where clause ?

@praweengupta6272 Жыл бұрын

can anyone tell me why my third statement of execution is wrong saying incorrect argument for execution (err code: 1210) # when records are improper or some records are missing or deleted set @count = (select count(id)/2 from employee_info) ; prepare stat from 'select * from employee_info limit ?' ; execute stat using @count;

@ShivamKendre-fc3su 3 жыл бұрын

Very nice explain maam

@CodeEra2020 3 жыл бұрын

Thank you so much..

@sandeshc6059 2 жыл бұрын

THANK YOU MAM

@CodeEra2020 2 жыл бұрын

Most welcome 😊 Thank you for watching.

@tribhuwankumar7052 3 жыл бұрын

Good explain

@CodeEra2020 3 жыл бұрын

Thank you so much..

@NehaYadav-wq8fg 3 жыл бұрын

Very nice video 😍

@CodeEra2020 3 жыл бұрын

Thank you so much

@CodeEra2020 3 жыл бұрын

Glad you like it

@rishabhrishu1602 2 жыл бұрын

thanqq ma'am please make some video on interview question

@CodeEra2020 2 жыл бұрын

Sure. Thank you so much for watching.

@rajt5218 2 жыл бұрын

Good 👍

@CodeEra2020 2 жыл бұрын

Thank you so much for watching.

@GojoXP 2 жыл бұрын

i want a query to display the name of all employs who has a unique later let consider we have three data bases virat dhoni and sachin among this using "i" we have to print sachin and dhoni please help me

@beingrishi6450 4 ай бұрын

2:05 Is there would be one table or two tables? One as E1 and another as E2?

@priyadarshini3284 6 ай бұрын

Can u explain how it's delete 7,8 I'd. I'm confused in 1st query.

@ashishgoyal4818 3 жыл бұрын

your videos are very good but you should explain the solutions a bit more precisely as I some of the questions I have seen on leetcode & to understand the solutions we don't have any source unless anybody explaining itin discussion section.

@CodeEra2020 3 жыл бұрын

I can understand you problem you can as your doubt here or you can join our telegram channel for further discussion. I will try to provide you best solution Thank you for watching

@ajaypalsingh2807 3 жыл бұрын

Output bhi thodi explain kra kro thoda jyada

@tinendrakumar4779 2 жыл бұрын

Good work...Could you please upload all 9 questions as a text file... thanks...

@CodeEra2020 2 жыл бұрын

We will try. Thank you for watching.

@alphasquaretarget2.017 2 жыл бұрын

@@CodeEra2020 mam please provide in pdf form we are waiting for your results

@rahulfukate3064 2 жыл бұрын

@beingrishi6450 4 ай бұрын

3:06 do we have to create 2 different tables for this query

@kanchidoshi6907 2 жыл бұрын

Can you please create a video on window functions?

@CodeEra2020 2 жыл бұрын

sure , I will make a video on it. Keep watching

@090-jellabharath2 11 ай бұрын

Madam ji You should have drawn the tables while explaning.

@chaitanyakrishna7750 3 жыл бұрын

Mam, I have AdP technical round They said prepare Sql More what questions will ask u know pls suggest most FAQ's in sql for freshers

@CodeEra2020 3 жыл бұрын

See there are a lot of question they can ask.. As here sql come up with DBMS so also prepare that. Some of theme are - 1) Joins. 2) Indexing 3) Relationship 4) DDL,DML,DCL 5) Different type of constraints we use in SQL 6) Types of keys And Some basic query you will find on my videos . All the Very Best for your Interview👍.

@chaitanyakrishna7750 3 жыл бұрын

@@CodeEra2020 thanks 😊 mam 🙌

@namratanagvekar6857 2 жыл бұрын

mast kam karti he tu

@MrShaileshpal 2 жыл бұрын

to tu bhi kar naa re

@beingrishi6450 4 ай бұрын

3:08 Where's the duplicate value in the sql command prompt i can see any duplicacy

@AkashKhan-km4xf 3 жыл бұрын

Will these queries work in Oracle SQL ?

@CodeEra2020 3 жыл бұрын

No may be some keyword not supported by Oracle but logic will be same.

@setairpackage2873 Жыл бұрын

HI, IAM SRINIVAS PLZ PROVIDE IF ANY MSBI MATERIALS LIKE SSIS,SSAS,SSRS....

@AkashKumar-ls7hg Жыл бұрын

we can also a short query for question no 8 select * from employee_info order by salary DESC limit 2; for maximum two salary select * from employee_info order by salary ASC limit 2; for minimum two salary

@nishantmishra7639 8 ай бұрын

exactly we can

@ashishkhandar9668 2 жыл бұрын

mam can you explain query in which we need to use different tables means all data is not in single table.

@CodeEra2020 2 жыл бұрын

In upcoming video we will try to use two tables.. Thank you for watching

@AjayKumar-ut3fs 2 жыл бұрын

Please add subtitles

@_ishan8130 2 жыл бұрын

Can't we use ''TOP 50 PERCENT" to get 50% of the table

@vasimuddinsheikh3766 2 жыл бұрын

Same query, and it works fine weather it is in sequence or not

@souvikghosh7872 2 жыл бұрын

For the 2 Minimum Salary and 2 maximum salary we can use ROWNUM clause or Top Clause for MySQL and arrange the Salary coloumn in Asc for min and Desc for Max

@monke890 Жыл бұрын

yes ofc but only if youre a noob

@ShivamKendre-fc3su 3 жыл бұрын

Maam apane ye video and isase pahela video ye do videos mai jitani queries padhai hai kya vo sufficient hai interview ke liye ??

@CodeEra2020 3 жыл бұрын

These are the important query but there can be N number of possible queries but if you have done these you can write the logic for the other..

@ShivamKendre-fc3su 3 жыл бұрын

@@CodeEra2020 yes maam thank you so much. I got this video just 2 days before my interview. Thanks to you

@CodeEra2020 3 жыл бұрын

@@ShivamKendre-fc3su You can also watch this its very important question kzfaq.info/get/bejne/fdGgbMJmtMqWn2g.html

@BhanupshRDY 2 жыл бұрын

May I know the written quires are in Oracle SQL or SQL server?

@CodeEra2020 2 жыл бұрын

MySQL

@BhanupshRDY 2 жыл бұрын

@@CodeEra2020 thank you so much

@nakulanand2725 2 жыл бұрын

Mam, i want to practice this queries but i cant access this files?

@CodeEra2020 2 жыл бұрын

Now You can Access those files. If not then please drop a comment.

@nakulanand2725 2 жыл бұрын

@@CodeEra2020 Thank you😊

@TheUttamkumarbagchi Жыл бұрын

Not SQL server! Your code doesn't work on SQL server!

@Bholenath_Shivala Жыл бұрын

Where is the pdf??

@CodeEra2020 Жыл бұрын

In the Description Box Link for SQL file- drive.google.com/file/d/1zra8F1MUirPEv_eU9kl7xxQAbyv9LRmi/view?usp=sharing Link for query PDF- drive.google.com/file/d/1D4hn8hU4J8toik1Rci9-TpEO5hK73Jn1/view?usp=sharing

@sunilmadgi4234 2 жыл бұрын

i have 3 tables 01) table employee (columns are empid,empname , depid) 02) table Department ( columns are depid, dep name) 03) table salary (columns are empid,amount,month). Q) get the empname , how don't get the salary in the month of December

@samrhymesful 2 жыл бұрын

did you try this?

@user-jc6te1vm8v Жыл бұрын

join 1st and 3rd table using emp_id as common kry and see if dec salary is null