HACKER RANK (SQL PROBLEM) CHALLENGES | URDU / HINDI

preview_player
Показать описание
#coding #challenges #SQL #Hacker_Rank #Problem_Solving #Urdu #Hindi #Solution #Education_Hub_Online #Education #sql_server

In this video, we have solved the HACKER RANK (SQL Problem Question) CHALLENGES | URDU | HINDI.
Рекомендации по теме
Комментарии
Автор

You explained really well,
how do you get the input values of table to use it in you local studio
because it takes a lot of extra useless effor to create and insert table values manually
thanks

AkashKumar-hgis
Автор

how did you imported the table values in local machine? pls tell...

pandeyRaman
Автор

There are two things:
1- The DISTINCT isn't needed at all, as after clause having count(c_compare) = 1, there remains nothing to filter for distinct.
2- I didn't get the 'OR' thing, because 'OR' is equal to = one of them, If one condition is true it will return the result, and if the first condition is true it won't check the second one, in our case first Having 'c_max' condition is true, because query did find the ' top 1' challenge_id, then why the second condition is getting executed? Isn't it should be returned after the first condition? And If we want both conditions to be executed, shouldn't we use AND instead of OR, but when I use AND, It reruns ' no response'. Please explain this!.

noumanmunir