Top 5 Advanced SQL Interview Questions and Answers | Frequently Asked SQL interview questions

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

Просмотров 25 тыс.

50% 1

In this video we will discuss most frequently asked top 5 Advanced SQL interview questions for experienced. We will also cover different variations of each questions. If you have any interview I am sure 2-3 questions will be from this list.
Kick off your data analytics journey: www.namastesql.com/
Zero to hero(Advance) SQL Aggregation:
• All About SQL Aggregat...
Most Asked Join Based Interview Question:
• Most Asked SQL JOIN ba...
Solving 4 Trick SQL problems:
• Solving 4 Tricky SQL P...
Data Analyst Spotify Case Study:
• Data Analyst Spotify C...
Top 10 SQL interview Questions:
• Top 10 SQL interview Q...
Interview Question based on FULL OUTER JOIN:
• SQL Interview Question...
Playlist to master SQL :
• Complex SQL Questions ...
Rank, Dense_Rank and Row_Number:
• RANK, DENSE_RANK, ROW_...
#sql #analytics

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

26 мар 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@ankitbansal6 Месяц назад

Here is the detailed explanation of question number 5. Please do like the video to help me reach to more people. Thanks in advance 🙏🙏 Most asked SQL interview question: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xR87ctOgpAE.html

@SinghSahab-gg1ow Месяц назад

request to u pls pls provide same data for practice

@nikhilsharma-jj6vd Месяц назад

Hi Sir, I recently got a sql question in HackerRank Interview for Techincal support engineer. Can you give us a solution. If yes, how can I send you the question please revert sir

@ankitbansal6 Месяц назад

@@nikhilsharma-jj6vd send it on sql.namaste@gmail.com

@nikhilsharma-jj6vd Месяц назад

@@ankitbansal6 sure sir. Sir I've also sent you request on LinkedIn. Please accept

@nikhilsharma-jj6vd Месяц назад

@@ankitbansal6 sent sir please check

@heyrobined Месяц назад

Make More videos These are really good coverage of what kind of questions asked by companies

@aman_mashetty5185 Месяц назад

Great video as usual awesome....!👏👏

@sriharsha398 Месяц назад

Thank you sir for such valuable content with a clean explanation sir

@akashjha7277 Месяц назад

Excellent explanation sir, slow and clear

@JeetendraKasi 14 дней назад

Excellent explanation using data and common mistakes that someone can do while querying the data.

@prateekkumar-xc6uo Месяц назад

Hello Ankit , excellent explanation of sql concepts thanks for sharing with all . could you pls share the dataset for this?

@varunl6948 Месяц назад

This was helpful!

@aadarshchaudhari3957 Месяц назад

Great explanation 👏

@vamsivamsi2029 Месяц назад

Thanks ankit

@shwetamishra1497 Месяц назад

Very informative video. Please provide us data for practice.

@udhaybhaskarbellamkonda1678 Месяц назад

Good Content,Keep it up 😊

@kaustavraytalukdar5466 Месяц назад

Helpful video, dataset please.

@dfkgjdflkg Месяц назад

As usual, I love your content. Original, helpful and puzzling how you find the solutions. Original content

@ankitbansal6 Месяц назад

Glad you enjoy it!

@udayakumar9949 Месяц назад

Really like your content. Please create for python also

@gauravsati1041 Месяц назад

Its very informative video, can you please share the dataset also?

@zuhebkhan6973 19 дней назад

Thanks in advance

@temik6500 Месяц назад

Hi Ankit, Thank you for what you're doing. Very interesting scenarios. How can one get access to the table's data pls? I was able to create the employee table for practice but the order table was not visible enough as it's more volumunous. This will be helpful for practice purpose. Many thanks

@raghibelahi937 День назад

Thank you so much sir. Could you please share the dataset.

@prabhac2273 6 дней назад

Excellent and clear explanation. Thanks for uploading.

@ankitbansal6 6 дней назад

You are welcome!

@shikharsaxena8984 Месяц назад

Very helpful video Ankit 👏👏🙂

@ankitbansal6 Месяц назад

Glad to hear that

@chiranjitdey3788 Месяц назад

Hi Ankit, Can you help solve this question. This question was asked to me in one of the interviews for data analyst position. Write an SQL query to find out the employees whose salary got increased at least 115% compared to the previous maximum salary. The result output should contain the following columns such as employee_name, salary, and salary_growth_percentage.

@niharranjandhar3457 Месяц назад

Inner 8 Left 8 Right 9

@madhustips8304 Месяц назад

really awesome content

@ankitbansal6 Месяц назад

Thank you 😊

@sravankumar1767 19 дней назад

Superb explanation Ankit👌 👏 👍

@ankitbansal6 19 дней назад

Thank you 🙂

@krsnabnsl 6 дней назад

Hi @Ankit, can you please provide data link, so we can test on your own.

@rk-ej9ep Месяц назад

This is awesome..I subscribed to ur paid course also..

@ankitbansal6 Месяц назад

Great. Thankyou 😊

@sravyasrinivas Месяц назад

Hi ankit. Could you please share the DDL script for these questions.

@Robert-uw8dn Месяц назад

Hey Ankit, could you please share the data to practice

@minakshityagi7785 Месяц назад

How to find roling quater sales? Ankit Sir can you reply with sql query?

@Chetan_15 9 дней назад

Q1. i want to show top 3 salllary employee but i used * before Top 3 how we get to know the position

@anikeetdey3411 Месяц назад

plz share the insert query , so that we can practice along with you

@Leo-qo5hk Месяц назад

Hello Ankit could you please share the script for this queries

@sonalpriya6402 Месяц назад

Please share dataset for practice

@indiebadger5225 Месяц назад

Hello Ankit, which screen recording application do you use? And if I am on a call with some, will the recording take their sound as well. Thanks

@ankitbansal6 Месяц назад

I use chrome extension for screen recording

@macx8360 Месяц назад

sir dataset plz

@sravankumar1767 19 дней назад

Can you please take one scenario and explain using where & And condition output results for each joins

@ankitbansal6 19 дней назад

Check this out ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Ypwfq5tNw-4.html

@pranaykukadkar7092 25 дней назад

@ankitbansal6 Please provide the sample data for order table for practise purpose. Thank you

@maqbul313 Месяц назад

Please provide employee and orders table scripts for download. Thank you

@anchal7876 Месяц назад

where i can find syntax?

@nevergiveup3475 Месяц назад

First comment❤

@AbhishekKumar-gf4db Месяц назад

Thanks #ankit sir, for this important video. Please 🙏 create a separate video for how to deal with HR,when she asks why you want to leave your job now,you have only 1 year experience.

@zuhebkhan6973 19 дней назад

Hi Ankit Bhai I love your work and I have learnt lot from ur videos as from non IT background I have learnt lot from ur end and started giving interviews for IT sector Today I had interview and they had asked one question on sql Like we have a table with row as string Table1 A B C now they need output as Abc Bac Cab Bac like wise plse help me making this video it will great help to me and other like me

@ankitbansal6 19 дней назад

What's the logic here .?

@zuhebkhan6973 19 дней назад

Even I'm clue less they ask me to get column as crossponding each letter

@vishalsonawane.8905 Месяц назад

@ankitbansal6 Sir content is incomplete until u can not provide your dataset link in description in video :)

@krishnatripathi5461 День назад

Share the dataset please

@yashwanthgaming137 Месяц назад

Que: In a month vendor is null then replace with previous month vendors. Input: Year | Vendor | Amt 1-2021 | A | 100 1-2021 | B | 200 1-2021 | C | 300 2-2021 | Null | Null 3-2021 | A1 | 210 3-2021 | B1 | 230 4-2021 | Null | Null output: Year | Vendor | Amt 1-2021 | A | 100 1-2021 | B | 200 1-2021 | C | 300 2-2021 | A | 100 2-2021 | B | 200 2-2021 | C | 300 3-2021 | A1 | 210 3-2021 | B1 | 230 4-2021 | A1 | 210 4-2021 | B1 | 230 How to solve this question Ankit Sir

@user-dw4zx2rn9v Месяц назад

with cte as ( select * , lag(grp) over (order by date) as prev_grp from (select date, group_concat(vendor) as grp from sales group by date) as x ) , cte2 as (select date, grp from cte union all select date, prev_grp as grp from cte ) ,cte3 as ( select * from cte2 where grp is not null ) SELECT date, SUBSTRING_INDEX(SUBSTRING_INDEX(grp, ',', n), ',', -1) AS grp FROM cte3 CROSS JOIN (SELECT 1 AS n UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4) AS numbers WHERE n

@jaychavan119 Месяц назад

Please provide the Database

@usharanikallubhavi7466 24 дня назад

at around 16:50 time of the video, NULL has been replaced by sales. So, we have got the same value in row1 for both sales and previuos_year_sales columns. But, logically speaking there’s no year previous to 2018, so the previous_year_sales should have been 0, isn’t it. Please clarify. Thanks.

@ankitbansal6 24 дня назад

If we consider it has 0 then growth will be very high. The same means no growth as the company just started .

@usharanikallubhavi7466 24 дня назад

@@ankitbansal6 Appreciate the quick response.