Biggest Single Number | Leetcode 619 | Crack SQL Interviews in 50 Qs #mysql #leetcode

Want to crack SQL interviews? Check out our latest video!!!

A 50-questions SQL study plan to ace any interview.
This tutorial will walk you through the solution in easy steps. This is an easy-level question from Leetcode.

Consistency is what transforms average into excellence.
So be consistent & keep Coding💻!!

Timecodes
0:00 - Introduction
0:18 - Question Explanation
0:50 - Understanding Concept with the help of Example
2:09 - Writing SQL Query
3:28 - Explanation of SQL Query
4:18 - Outro

Connect With Me -

#coding
#leetcode
#mysql
#sql
#interview
#sqlinterview
#sqlinterviewquestionsandanswers
#sql_server
#learnwithchirag
#biggest
#single
#number

[learnwithchirag]

Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on

Instagram Handles :-



Let's stay connected and keep the creativity flowing! 💡

[tushargoswami]

Thanks bro, your explanation is awesome.

[prerakpanwar]

select max(num) as num from
(select num

from MyNumbers
group by num

having count(num) = 1) as a

[devsagar]

What's wrong with this query?

with num_cnt as(
select
num, count(*) as cnt
from MyNumbers
group by 1
order by 1 desc
)


select
-- coalesce(num, null) as num
if(num <> num, null, num) as num
-- (case when cnt != 1 then null else num end) as num
from num_cnt
where cnt=1
limit 1

[mobile_o_graphy]

how to know when to use subquery or not, 😕. What was your intuition? i also solved with subquerry but i don't know why!!😅

[sandeepvarma]

Bhai second example null ke liye kya karna hai uski query nahi likhi

[mdamirhussain]

select max(num) as num
from MyNumbers
where (num) IN
(select num from MyNumbers group by num having count(num) = 1)
group by num

maine ye likha tha ... Maloom nahi kyuu nahi chal raha hai ye