Комментарии:
left join should be better as it skip top manager id with inner join
ОтветитьThanks for the informative video. Also, can you help with the insert code for the data?
ОтветитьThanks, if you added table populated script that will very helpful.
Ответитьcan you help me solving a sql query for a database that contains three tables, AAID,cookies, IDAF
Column Headers
● Id_type
○ AAID
○ IDFA
○ Cookie
● Device_id
● Hashed_email (SHA256)
● Timestamp
○ Unix timestamp
● Ip_address
● Opted_out
○ 1, 0
○ 1 = opted out
Querys are
● Where device_id appears more than once AND has ID type IDFA & AAID - Delete all
● IF hashed email matches more than 50 IDs (sum of cookie, idfa, aaid) - Delete all
can this be deleted in single query?
If you share SQL query in the description would be so helpful
ОтветитьWoW simply wonderful😇
ОтветитьYou did for one level only, you can't get full & complete hierarchy with just one self join, if you can make it plz share
Ответить|----------------------------------------|
| abc / def /abc |
| abc def / abc / def |
| abcc/ def // abc/ abc |
| --------------------------------------|
this is the question what query should I write to get this answer
ANS--- |----------------------------|
| abc /def |
| abc/ def /def |
| abcc/ def/ |
|----------------------------|
it's an interview Question
Thank you mam for making such an amazing videos on sql , I have practice most of your videos of playlist 62 videos ..... Keep posting amazing videos
ОтветитьPlease make video for full hierarchy like parents ,son ,
Grand parents , grand children
What is the difference between union and Superlative Union?
ОтветитьThank you... your content is truly informative
ОтветитьThis is not hirearchy. hirearchy means a particular employee's entire hirearchy
ОтветитьI was asked to find all direct and indirect subordinates with given manager name🤦🏻♂️
Ответитьgreat video , Thanks
Ответитьthanks its really helpful
Ответитьkindly share how to print this hierarchy in single column like --> adam->natasha->mark in single column
Ответитьvery useful. I have been asked this question many times in interviews.
Ответитьwhy is it not mentioned as self join in self join and mentioned as inner join?
ОтветитьHow will you query to identify the circular references in employees and manager relationship?
ОтветитьThank you so much!!!
ОтветитьHave you been asked a SQL query interview question that you couldn't answer?
Let us know in the comments below and we will answer those in our upcoming videos!
The Boss who's value is Null record not appeared in the output, please check once...
ОтветитьGreat video. Please upload this type of queries mam...Thanks
Ответить