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

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

[@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');

[@mohansharma8095]

thanks man

[@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!

[@soumyadeep_bi]

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

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

[@talknow2859]

I definitely learnt something. Thanks.🎉

[@pridename2858]

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

[@pravinmahindrakar6144]

Crystal clear to me, thanks a lot!

[@abhishekgawali1921]

Very Nice Sesson, Crystal Clear Session

[@talknow2859]

Very helpful 🎉🎉🎉

[@nehamegha3384]

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

[@TrustinData]

Thank you so much for such simplified explanation sir

[@rohitavachar6389]

Thank you ☺️👏

[@arbazmohammad3290]

Good Explanation. Please Provide notes for this session.

[@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');

[@samidhashah542]

Very Helpful !!

[@sumitmittal07]

Thank you Samidha

[@killshot57]

Thanks legend 🙏🏻

[@adarshbharti8782]

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

[@sumitmittal07]

I am glad that you liked it

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

[@kunju4ful]

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

[@shaktijain8560]

After setup completion : 2:24

[@imrohan97]

Sir have you covered joins in this series?

[@slyroy7562]

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

[@swadhinsonwane4185]

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

[@amuladhanunjay7946]

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

[@sumitmittal07]

Will upload them shortly

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

[@naveenupadhye7285]

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

[@alfabinomial6183]

how may i suppose to get the txt file ?

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

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

[@harshrajvaghela699]

sound very slow