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

Подписаться 124 тыс.

Просмотров 4,7 тыс.

50% 1

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:
• 5 Days series- Solving...
✨Link to the video of Rank Functions in SQL:
• SQL Window Functions |...
✨Link to my e-books:
SQL e-book: imojo.in/rkajq9
'Switch your career easily' e-book: imojo.in/1FL7KaG
(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:
/ @crackconcepts
✨Work related mails can be sent on work.sadiasiddiqui@gmail.com
✨If you appreciate my work and would like to donate to support our channel, you can do so here : paypal.me/sadia1702
✨Please like, share, subscribe and comment down. It would make my day :)
Thank you, have a nice day!

Опубликовано:

16 окт 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 15

@crackconcepts 8 месяцев назад

✨Link to all the videos in this series can be found in this playlist: ru-vid.com/group/PLtPFQl_0853pmiE1cyZsGX7p5L-DytnyF&si=IFR0L8Ky8VF9rXVP ✨Link to my e-books: ▪️SQL e-book: imojo.in/rkajq9 ▪️'Switch your career easily' e-book: imojo.in/1FL7KaG (Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)

@vishnuvardhanreddy5986 8 месяцев назад

Thankyou for great session 😍😍

@sachinroge3509 7 месяцев назад

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

@amitkatkar8286 7 месяцев назад

This is very interesting questions, i like it.🎉

@reigngamer94 7 месяцев назад

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 🌟

@crackconcepts 7 месяцев назад

Wow, thank you!

@varunl6948 6 месяцев назад

Thanks for this!

@syedabdulawal4746 8 месяцев назад

Very useful.... From Bangladesh...

@Mahesh717 8 месяцев назад

Helpful 👍

@amitkatkar8286 7 месяцев назад

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;

@venukumargadiparthy8233 7 месяцев назад

Can we use Row_number also in this case?

@AzithKumar-ke9ef 5 месяцев назад

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; ??

@rishabhbhagwati5013 8 месяцев назад

🫡👌

@amitkatkar8286 7 месяцев назад

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 at.acct_type_c=atd.acct_type_c group by atd.type_desc;

@amitkatkar8286 7 месяцев назад

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 at.acct_type_c=atd.acct_type_c where atd.acct_type_c ='c' order by n.name_i;