Member since
11-18-2022
2
Posts
0
Kudos Received
0
Solutions
11-19-2022
05:59 AM
Hi Asish, Thanks for your replay I need top 5 game for each country, as you know limit 5 gives 5 rows only, but I need 5 for each country. this is the question: (Show the top 5 game Disciplines for the countries who got more than 10 gold medals) Thanks
... View more
11-18-2022
06:37 PM
Hi Sir, could you please help me with my simple code, I will be very appreciative, I have this question: Show the top 5 game Disciplines for the countries who got more than 10 gold medals. my code is: select distinct t.discipline, m.team from teams t join medals m on (t.noc=m.team and m.numbergold>10) order by m.team; cloud you please help me with this code to show the top 5 game? Thanks
... View more
Labels:
- Labels:
-
Apache Hive