Day 1: Solving TRICKY SQL Interview Queries | SQL Query Interview Questions

Hi, In this video we've discussed a tricky SQL Interview Question. This is a 5 days series where I will solve SQL Interview questions. I would highly recommend watching all the videos from this series if you want to master SQL
#sql #sqlinterviewquestionsandanswers #sqlinterview

✨Link to all the videos in this series can be found in this playlist:

✨Link to the video of Rank Functions in SQL:

✨Link to my e-books:
(Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)

✨Join this channel to get access to perks:

✨Please like, share, subscribe and comment down. It would make my day :)

Thank you, have a nice day!

[crackconcepts]

✨Link to all the videos in this series can be found in this playlist:

✨Link to my e-books:
(Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)

[sachinroge]

Great video. Can you also share the db table data so that everyone watching can practice on the same.

[reigngamer]

I've been following your videos from so many years. From becoming a data analyst to every upleveing interview I come to brush up my basics. Thanks for sharing such wholesome content and keep shining 🌟

[amitkatkar]

This is very interesting questions, i like it.🎉

[amitkatkar]

Mam this is 4 th questions answers

select * from
(select account_balance.*, dense_rank() over(partition by acct_i order by ac_date) d
from account_balance)
where d=2;

[venukumargadiparthy]

Can we use Row_number also in this case?

[AzithKumar-keef]

Can we achieve the same result using the below query

Select ACCT_I, DATE_I, BALN_AMT from ACCOUNT_BALANCE GROUP BY ACCT_I order by DATE_I DESC; ??

[amitkatkar]

Mam this is 2 nd questions answers, it's right or wrong????


select sum (ab.baln_amt), atd.type_desc from account_balance as ab inner join account_type as at
on ab.acct_i=at.acct_i inner join account_type_d as atd
on
group by atd.type_desc;

[amitkatkar]

Mam this is 3 rd questions answer, plz check it.


select (n.name||' '||np.name) full_name, atd.type_desc, atd.acct_type_c
from names n inner join account_name an
on n.name_i = an.first_name_i inner join names np
on np.name_i = an.last_name_i inner join account_type at
on an.acct_i= at.acct_i inner join account_type_d atd
on
where atd.acct_type_c ='c'
order by n.name_i;