greatest-n-per-group

133 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
SQL Server: How to de-duplicate on two columns/conditions?
user_852480
•
2
2
61
greatest-n-per-group where-clause tsql sql-server sql
Count number of records based on last updated date + null
user_94693160
•
2
1
101
snowflake-cloud-data-platform subquery greatest-n-per-group window-functions sql
Select random percentage from a table in Snowflake (while using the WHERE clause)
user_134855330
•
3
3
4511
snowflake-cloud-data-platform greatest-n-per-group window-functions where-clause sql
How to get latest messages for each user in mysql?
user_77981090
•
2
1
249
greatest-n-per-group window-functions datetime mysql sql
SQL Server : SELECT query to get DISTINCT and MAX display order value
user_98109210
•
2
1
183
hierarchical-data greatest-n-per-group window-functions sql-server sql
How do I calculate the percentage of dollar amount of approved orders out of total dollar amount of orders placed?
user_117739480
•
2
2
120
greatest-n-per-group sum mysql average sql
How to find Min and Max rows from a table including all columns from postgresql
user_79403650
•
4
2
1406
greatest-n-per-group window-functions postgresql sql
SQL select the record whose HIGHEST timestamp is the LOWEST
user_119401190
•
2
1
142
greatest-n-per-group max sql-order-by postgresql sql
Laravel 6, MYSQL - How to Left Join a Sub Query with GroupBY using Laravel Querybuilder or Model Eloquent?
user_106272430
•
2
1
208
eloquent laravel greatest-n-per-group mysql php
use group by to get n smallest values but with duplicates
user_52661760
•
2
1
161
pandas greatest-n-per-group python
Hot Questions