greatest-n-per-group

133 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Select 2 products per city with most counts in PostgreSQL
user_117934910
•
2
1
147
greatest-n-per-group row-number postgresql sql
Query to display employees with lowest salary from each department
user_157538710
•
2
2
1101
greatest-n-per-group postgresql sql
RETURNING causes error: missing FROM-clause entry for table
user_22533230
•
2
2
2740
sql-returning sql-insert greatest-n-per-group postgresql sql
Postgres find unique values ​in json
user_116886680
•
2
2
56
greatest-n-per-group postgresql sql json
Select most recent value in a group
user_6499220
•
4
2
147
sql-server-2019 greatest-n-per-group group-by sql-server sql
How to remove duplicate data in MySQL
user_155291640
•
2
4
112
mysql-8.0 greatest-n-per-group mysql sql
How to update a column with unique serial number depending on two different columns of the same rows in PostgreSQL?
user_97450950
•
3
2
641
greatest-n-per-group row-number postgresql stored-procedures sql
Filter data based on group SQL Netezza
user_57380920
•
1
2
140
netezza greatest-n-per-group filter sql
Get values appearing at least N times in a table quickly
user_129254710
•
3
1
70
postgresql-performance greatest-n-per-group indexing postgresql sql
Get max ID for every Type and every Date from a lookup table
user_1806850
•
3
5
165
greatest-n-per-group mysql sql
Hot Questions