Hi all,
I tried to solve the following problem. But somehow I have one problem how do I get the most 3 populated city? Do I have to use the partition over by? If yes where exactly?


Hi all,
I tried to solve the following problem. But somehow I have one problem how do I get the most 3 populated city? Do I have to use the partition over by? If yes where exactly?


That's to less on information.
Please post table design as DDL, some sample data as DML statement and the expected result.
Hey!
I've modified the tags in your post for the closest one that I could find from the list. Your original tags were related to "Power Query" and not SQL.
You can learn more about Microsoft Power Query from the link below:
https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query
Best!
3 people are following this question.