Very Important SQL Interview question | Over Clause | Partition By Clause

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!
"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."
𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLINR
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐨𝐮𝐭𝐬𝐢𝐝𝐞 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLUSD
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐁𝐢𝐠 𝐃𝐚𝐭𝐚 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫?
𝐜𝐡𝐞𝐜𝐤𝐨𝐮𝐭 𝐭𝐡𝐞 𝐛𝐢𝐠 𝐝𝐚𝐭𝐚 𝐜𝐨𝐮𝐫𝐬𝐞 𝐝𝐞𝐭𝐚𝐢𝐥𝐬
𝐖𝐞𝐛𝐬𝐢𝐭𝐞 : trendytech.in/...
I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.
Very Important SQL Interview question | Over Clause | Partition By Clause
In this session we will learn over clause in mysql
Do Like, Comment & Subscribe :)
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
🔅Sumit LinkedIn - / bigdatabysumit
🔅Sumit Instagram - / bigdatabysumit
#SQL #RDBMS #database #bigdata #dataengineering

[@sumitmittal07]

Checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql14

[@evilruzario8513]

CREATE TABLE employee (
firstname varchar(20),
lastname varchar(20),
age int,
salary int,
location varchar(20)
);
INSERT INTO employee VALUES ('sachin','sharma', 28, 10000,
'bangalore');
INSERT INTO employee VALUES ('shane', 'warne', 30, 20000,
'bangalore');
INSERT INTO employee VALUES ('rohit', 'sharma', 32, 30000,
'hyderabad');
INSERT INTO employee VALUES ('shikhar', 'dhawan', 32,
25000, 'hyderabad');

[@manishlakhera2718]

Thanks Evil for this SQL Script.

[@PiyushAtghara]

Good quality 'structured' learning material is rarely available for free. I can understand the hard work that goes into it.
Thanks for all of it!

[@pavanbv25]

For reference I have created sample data,
create table employee(
first_name varchar(20),
last_name varchar(20),
age int,
salary int,
location varchar(20));
insert into employee values('sachin','sharma',28,10000,'Bangalore');
insert into employee values('pavan','sharma',30,10000,'Bangalore');
insert into employee values('rohit','sharma',31,10000,'hydrabad');
insert into employee values('shekar','sharma',32,10000,'Bangalore');
insert into employee values('Rahul','sharma',33,10000,'hydrabad');
insert into employee values('saurabh','sharma',30,10000,'pune');
insert into employee values('kapil','dev',28,10000,'pune');

[@soumyadeep_bi]

It would be nice if you also include the insert queries along with the videos in the description

[@talknow2859]

I definitely learnt something. Thanks.🎉

[@pridename2858]

Wow!!!,another mind blowing session with ease, Thank you sir...we are learning

[@TrustinData]

Thank you so much for such simplified explanation sir

[@arbazmohammad3290]

Good Explanation. Please Provide notes for this session.

[@rareflower88]

The exact SQL that has all of Sumit's data and correct names, salary and ages, and exact column names used in this example:
CREATE TABLE employee (
firstname varchar(20),
lastname varchar(20),
age int,
salary int,
location varchar(20));
INSERT INTO employee VALUES ('sachin','sharma',28,10000,'bangalore');
INSERT INTO employee VALUES ('shane','warne',30,20000,'bangalore');
INSERT INTO employee VALUES ('rohit','sharma',32,30000,'hyderabad');
INSERT INTO employee VALUES ('shekar','sharma',32,25000,'hyderabad');
INSERT INTO employee VALUES ('rahul','dravid',31,20000,'bangalore');
INSERT INTO employee VALUES ('saurabh','ganguly',32,15000,'pune');
INSERT INTO employee VALUES ('kapil','dev',34,10000,'pune');

[@LokeshSabale]

We will also use order by under over clause after partition by because it gives an answer in a sorting manner

[@nehamegha3384]

Don't know how to thanku for this great explanation 😍😍

[@pravinmahindrakar6144]

Crystal clear to me, thanks a lot!

[@kunju4ful]

This was the great concept taught with the benefit of using it..Thank you Sumit !!

[@pandulaajay7095]

@sumitmittal07 sir at 14:36 you said we cannot use non aggregated values with group by but while using group by we need to non aggregated values also na if not we ll get error i was a bit confused on thiss can you please explain

[@talknow2859]

Very helpful 🎉🎉🎉

[@abhishekgawali1921]

Very Nice Sesson, Crystal Clear Session

[@vishnujatav6329]

Great session. how many more session will be there in completing the SQL?? am I eligible to face an interview If I have learn everything you have taught so far??

[@sumitmittal07]

Absolutely.. many more sessions to come.

[@adarshbharti8782]

Amazing crystal clear..... Thanx a lot sir.

[@sumitmittal07]

I am glad that you liked it

[@basudevdash3726]

Hi sir, just wanted to know how many more concepts/lecture videos will be uploaded?

[@smyphysics]

till now 13 i hope..

[@basudevdash3726]

@@smyphysics that I know, because all are present in playlist.
I am asking about future lectures.

[@samidhashah542]

Very Helpful !!

[@sumitmittal07]

Thank you Samidha

[@rohitavachar6389]

Thank you ☺️👏

[@killshot57]

Thanks legend 🙏🏻

[@swadhinsonwane4185]

sir before using partition you should have explained it first. so it becomes easy for us to understand the concept behind the query.

[@imrohan97]

Sir have you covered joins in this series?

[@amuladhanunjay7946]

Sir please provide all sessions notes, it's more helpful to us

[@sumitmittal07]

Will upload them shortly

[@slyroy7562]

Hi sir,
Can you make one video in Date functions and some scenarios?

[@vishnujatav6329]

Why so small session as you provide only 2 session a week, I request you to provide one session each day if session are like this much small or create 1 hour session (covering whole topic like WINDOW function in today's session) if 2 session in a week. Thank you

[@alfabinomial6183]

how may i suppose to get the txt file ?

[@naveenupadhye7285]

IF YOU PROVIDE THE DATASET AS DOCUMENTS THEN IT WOULD BE GREAT TO COMPARE THE RESULTS

[@shaktijain8560]

After setup completion : 2:24

[@harshrajvaghela699]

sound very slow

[@learner-xu5tw]

CREATE TABLE employee (
firstname varchar(20),
lastname varchar(20),
age int,
salary int,
location varchar(20)
);
INSERT INTO employee VALUES ('sachin', 'sharma', 28, 10000, 'bangalore');
INSERT INTO employee VALUES ('shane', 'warne', 30, 20000, 'bangalore');
INSERT INTO employee VALUES ('rohit', 'sharma', 32, 30000, 'hyderabad');
INSERT INTO employee VALUES ('shikhar', 'dhawan', 32, 25000, 'hyderabad');
INSERT INTO employee VALUES ('rahul', 'dravid', 31, 20000, 'bangalore');
INSERT INTO employee VALUES ('saurabh', 'ganguly', 32, 15000, 'pune');
INSERT INTO employee VALUES ('kapil', 'dev',34, 10000, 'pune');