Very Important SQL Interview question | Over Clause

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

Рет қаралды 60,761

2 жыл бұрын

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!
"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."
𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLINR
𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 𝐋𝐢𝐧𝐤 (𝐂𝐨𝐮𝐫𝐬𝐞 𝐀𝐜𝐜𝐞𝐬𝐬 𝐟𝐫𝐨𝐦 𝐨𝐮𝐭𝐬𝐢𝐝𝐞 𝐈𝐧𝐝𝐢𝐚) : rzp.io/l/SQLUSD
𝐖𝐚𝐧𝐭 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐁𝐢𝐠 𝐃𝐚𝐭𝐚 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫?
𝐜𝐡𝐞𝐜𝐤𝐨𝐮𝐭 𝐭𝐡𝐞 𝐛𝐢𝐠 𝐝𝐚𝐭𝐚 𝐜𝐨𝐮𝐫𝐬𝐞 𝐝𝐞𝐭𝐚𝐢𝐥𝐬
𝐖𝐞𝐛𝐬𝐢𝐭𝐞 : trendytech.in/?src=youtube&su...
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

Пікірлер: 41

@sumitmittal07 Жыл бұрын

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

@evilruzario8513 Жыл бұрын

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

@PiyushAtghara 2 жыл бұрын

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!

@talknow2859 22 күн бұрын

I definitely learnt something. Thanks.🎉

@kunju4ful Жыл бұрын

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

@pravinmahindrakar6144 2 жыл бұрын

Crystal clear to me, thanks a lot!

@TrustinData Жыл бұрын

Thank you so much for such simplified explanation sir

@pridename2858 10 ай бұрын

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

@abhishekgawali1921 2 жыл бұрын

Very Nice Sesson, Crystal Clear Session

@soumyadeep_bi 2 жыл бұрын

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

@talknow2859 Ай бұрын

Very helpful 🎉🎉🎉

@LokeshSabale Жыл бұрын

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

@rohitavachar6389 2 жыл бұрын

Thank you ☺️👏

@nehamegha3384 Жыл бұрын

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

@arbazmohammad3290 Жыл бұрын

Good Explanation. Please Provide notes for this session.

@killshot57 Жыл бұрын

Thanks legend 🙏🏻

@pandulaajay7095 2 ай бұрын

@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

@slyroy7562 2 жыл бұрын

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

@adarshbharti8782 2 жыл бұрын

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

@sumitmittal07 2 жыл бұрын

I am glad that you liked it

@imrohan97 2 жыл бұрын

Sir have you covered joins in this series?

@rareflower88 9 ай бұрын

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

@alfabinomial6183 Жыл бұрын

how may i suppose to get the txt file ?

@samidhashah542 2 жыл бұрын

Very Helpful !!

@sumitmittal07 2 жыл бұрын

Thank you Samidha

@vishnujatav6329 2 жыл бұрын

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

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

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

@sumitmittal07 2 жыл бұрын

Will upload them shortly

@rajpali8410 2 жыл бұрын

Sir Can I get Notes...??

@naveenupadhye7285 Жыл бұрын

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

@vishnujatav6329 2 жыл бұрын

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

Absolutely.. many more sessions to come.

@shaktijain8560 9 ай бұрын

After setup completion : 2:24

@basudevdash3726 2 жыл бұрын

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

@smyphysics 2 жыл бұрын

till now 13 i hope..

@basudevdash3726 2 жыл бұрын

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

@harshrajvaghela699 2 жыл бұрын

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