Data Science, Python, Pandas.
filtering out the rows with the maximum ’n’ values for a given article. Here is the full SQL query: SELECT t.article, t.coming_from, t.n FROM ( SELECT row_number() OVER ( PARTITION BY article ORDER BY n DESC ) ArticleNR, article, coming_from, n FROM article_sum ) t WHERE t.ArticleNR = 1 ORDER BY n