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

In this video we will see advanced #Top 9 #SQL query Which are very important for the #PlacementPreparation

✔Link for SQL file-

✔Link for query PDF-

⭐Part 1:Top 9 SQL queries for interview -

⭐Create MySQL Database and Table -

TCS NQT Sample Paper:

TCS NQT Sample Paper solutions:

TCS NQT 2021 Complete Registration Process | Exam Pattern

✔Difference between oop and pop :

💥Access Modifier in Java-Public,Protected,Private and Default

💥Constructor in Java

💥Part 3 of 3 :Database Connectivity

💥Part 2 of 3 :Database Connectivity

💥Part 1 of 3 :Database Connectivity

⭐Encapsulation in java-

⭐DBMS vs RDMS

⭐Keys in DBMS

⭐Normalization in DBMS-

⭐class and object in java-

⭐Types of key in DBMS-

⭐how to install java-

⭐Introduction of java:-

⭐Features of java:-

⭐JVM JRE JDK:-

⭐JVM architecture-

#mysql #oracle #dbms #query #top #sqlserver #database

[CodeEra]

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

[priyansha]

Very nice video for quick revision. thank you

[shaziasamreen]

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.

[anjalisaini]

thanks maam .. this video is very helpful

[sachinupreti]

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

[ramagirisurendra]

can u explain difference between oracle nd my sql dbs.

[rishabhrishu]

thanqq ma'am please make some video on interview question

[ajaypalsingh]

Output bhi thodi explain kra kro thoda jyada

[tinendrakumar]

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

[beingrishi]

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

[ashishgoyal]

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.

[beingrishi]

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

[kanchidoshi]

Can you please create a video on window functions?

[GojoXP]

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

[AkashKumar-lshg]

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

[-jellabharath]

Madam ji
You should have drawn the tables while explaning.

[praweengupta]

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;

[beingrishi]

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

[priyadarshini]

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