No video
Leetcode SQL Interview Questions | Practise SQL questions
ะ ะตั าะฐัะฐะปะดั 21,875
ะาฏะฝ ะฑาฑััะฝ๐๐๐ง๐ญ ๐ญ๐จ ๐๐๐ฌ๐ญ๐๐ซ ๐๐๐? ๐๐๐๐ซ๐ง ๐๐๐ ๐ญ๐ก๐ ๐ซ๐ข๐ ๐ก๐ญ ๐ฐ๐๐ฒ ๐ญ๐ก๐ซ๐จ๐ฎ๐ ๐ก ๐ญ๐ก๐ ๐ฆ๐จ๐ฌ๐ญ ๐ฌ๐จ๐ฎ๐ ๐ก๐ญ ๐๐๐ญ๐๐ซ ๐๐จ๐ฎ๐ซ๐ฌ๐ - ๐๐๐ ๐๐ก๐๐ฆ๐ฉ๐ข๐จ๐ง๐ฌ ๐๐ซ๐จ๐ ๐ซ๐๐ฆ ๐๐ฒ ๐๐ฎ๐ฆ๐ข๐ญ ๐๐ข๐ซ!
"๐ 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.
Leetcode SQL Interview Questions | Practise SQL questions
182. Duplicate Emails
183. Customers Who Never Order
Do Like, Comment & Subscribe ..
๐๐ผ๐ถ๐ป ๐บ๐ฒ ๐ผ๐ป ๐ฆ๐ผ๐ฐ๐ถ๐ฎ๐น ๐ ๐ฒ๐ฑ๐ถ๐ฎ:๐ฅ
๐
Sumit LinkedIn - / bigdatabysumit
๐
Sumit Instagram - / bigdatabysumit
In this video, we will solve SQL question on LeetCode. LeetCode is an excellent platform for practicing SQL Queries. The SQL Questions on LeetCode are framed pretty similar to how they are asked on SQL Interviews hence solving SQL questions on LeetCode can give you a good hands on experience on solving real world SQL questions.
#SQL #RDBMS #database #bigdata #dataengineering
@sumitmittal07 ะัะป ะฑาฑััะฝ
Checkout the Big Data course details here: trendytech.in/?referrer=youtube_lc4
@shivangikhanna6163 2 ะถัะป ะฑาฑััะฝ
I got this question in one of the interviews last week. You are just late by few days ๐
. Just kidding! Incredible content Sumit sir.
@mohammadshahfaishal2747 2 ะถัะป ะฑาฑััะฝ
#duplicate email.You don't need to write a derived table. You can do it one email. "Select email from table_name group by 1 Having count(*)> 1"
@souvik5560 2 ะถัะป ะฑาฑััะฝ
Loved it ๐๐ผ Thank you for the session. It would be really great if you could explain why one query is better than the other query. The interviews do ask for optimisation and the basis for it.
@sumitmittal07 2 ะถัะป ะฑาฑััะฝ
Glad that you are liking the sessions. Yes, will cover it in the upcoming videos.
@Anonymous_it_is 2 ะถัะป ะฑาฑััะฝ
Thanks for this video sir. Alternate solution using Partition : SELECT DISTINCT email FROM (SELECT email, COUNT(email) OVER (PARTITION BY email) AS part FROM Person) AS temp WHERE temp.part > 1; Sir, could you please explain - is there any performance differentiation between the above query and the query shown in video. Thank You!
@abhisheksuman6592 2 ะถัะป ะฑาฑััะฝ
Very Informative ๐ Continue this series as it will help a lot to people looking to crack data analyst interview.
@sakshijain3534 5 ะฐะน ะฑาฑััะฝ
with cte as(select email ,row_number() over(partition by email order by email) as rn from person) select distinct email from cte where rn > 1;
@mallikarjunpatil7553 2 ะถัะป ะฑาฑััะฝ
Thanks for very nice explanation.. Waiting for the premium questions
@arunsundar3739 4 ะฐะน ะฑาฑััะฝ
able to solve sql problems on my own now :)
@shananwar3199 2 ะถัะป ะฑาฑััะฝ
Thanks a lot, waiting for next session.
@sumitmittal07 2 ะถัะป ะฑาฑััะฝ
Very soon :)
@manoharmanu9354 9 ะฐะน ะฑาฑััะฝ
select name from customers where id not in(select customerID from orders)
@sayantansarbadhikary6917 3 ะฐะน ะฑาฑััะฝ
๐
@akkiwadhwa6618 ะัะป ะฑาฑััะฝ
Jb nhi pta kyu btara hai..Chu
@pragyajaiswal5754 2 ะถัะป ะฑาฑััะฝ
select Customers.name as "Customers" from Customers join Orders ON Customers.id != Orders.customerid; Can someone point out where i am doing wrong?
Sumit Mittal
ะ ะตั าะฐัะฐะปะดั 24 ะ.
Sumit Mittal
ะ ะตั าะฐัะฐะปะดั 35 ะ.
ะะพะน ะะฝะธะผะฐัะธั
ะ ะตั าะฐัะฐะปะดั 1,1 ะะะ
GlowWoW
ะ ะตั าะฐัะฐะปะดั 10 ะะะ
Ankit Bansal
ะ ะตั าะฐัะฐะปะดั 229 ะ.
Sumit Mittal
ะ ะตั าะฐัะฐะปะดั 31 ะ.
Ankit Bansal
ะ ะตั าะฐัะฐะปะดั 18 ะ.
Analytics Vidhya
ะ ะตั าะฐัะฐะปะดั 53 ะ.
Ankit Bansal
ะ ะตั าะฐัะฐะปะดั 10 ะ.
Ankit Bansal
ะ ะตั าะฐัะฐะปะดั 22 ะ.
Lotus IT Hub training institute
ะ ะตั าะฐัะฐะปะดั 110 ะ.