Data Analyst Interview Questions I SQL Interview Questions

No video

Data Analyst Interview Questions I SQL Interview Questions | SQL Interview Queries

Рет қаралды 9,177

Күн бұрын

Data Analyst Interview Questions
SQL Playlist: • Oracle SQL
Interview Preparation: / playlistlist=ploah_5_4...
Code: drive.google.c...
Keywords: sql interview questions,sql interview questions and answers,data analyst interview,data analyst interview questions,data analyst interview questions and answers,interview questions sql,data analyst,data analyst interview questions for freshers,sql interview questions for freshers,sql interview questions for experienced,sql interview questions and answers for freshers,sql interview,data analytics interview questions,sql interview questions for beginners

Пікірлер: 23

@suhaschandras4318 Ай бұрын

Awesome 👍

@user-ut1kc6rg3u Ай бұрын

@@suhaschandras4318 Thanks for watching

@user-lm1gk5rf8q 7 ай бұрын

Great video sir. Thank You ❤

@user-ut1kc6rg3u 6 ай бұрын

Thanks for watching

@malcorub 6 ай бұрын

Thank you for this video amigo! Is the WHERE a.team_no b.team_no really necessary? It seems like the following line with the < would be enough to ensure the row numbers are never equal.

@user-ut1kc6rg3u 6 ай бұрын

Thanks for watching. The answer for your question is as per requirement one team should play with other team only once (IND-AUS but not AUS-IND). So thats why we need to use above condition. And Yes < can be also possible. You can check at your end also.

@malcorub 6 ай бұрын

@@user-ut1kc6rg3u I will try it out. Thank you for your response. Keep up the great work!

@harshboda2922 6 ай бұрын

Very helpful video

@user-ut1kc6rg3u 6 ай бұрын

Thanks for watching

@user-lm1gk5rf8q 7 ай бұрын

Nice explanation

@user-ut1kc6rg3u 6 ай бұрын

Thanks for watching

@50_maheshpatil57 7 ай бұрын

🔥🔥🔥

@user-ut1kc6rg3u 7 ай бұрын

Thanks for watching

@ushasworld5223 8 ай бұрын

My small request could u please zoom in the query ur writing please because its so hard to seed

@user-ut1kc6rg3u 8 ай бұрын

Yes sure, for next video I will zoom into screen. Thanks for watching.

@Shanmugamanickavel 8 ай бұрын

Pam bro do u take private classes on query writing?? Also how do we know to use ntile and listtag ?? Please explain

@user-ut1kc6rg3u 8 ай бұрын

No I don’t take private classes. But if you want I can create a separate video on that.

@prabhatgupta6415 8 ай бұрын

bhai data bhi provide kr diya kro

@user-ut1kc6rg3u 8 ай бұрын

Yes uploaded. Check in Description box. Thanks for watching.

@AbhijitPaldeveloper 3 ай бұрын

Second question query answer in mysql- SELECT result, ROW_NUMBER() OVER(ORDER BY result) as `groups` FROM(SELECT GROUP_CONCAT(id,name) as result FROM(SELECT *, ROW_NUMBER() OVER(PARTITION BY ID%2) as part FROM `group` ORDER BY name ASC) as e GROUP BY part ORDER BY part ASC) as e1