greatest-n-per-group

133 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
How would I extract only the latest week from a select over statement in Hiveql?
user_139645630
•
3
1
31
hiveql gaps-and-islands greatest-n-per-group sql
postgres - select the "highest scored" column_name from left to right
user_145931440
•
2
2
83
greatest-n-per-group case postgresql sql
Postgres: Get value of a column corresponding to max of other column in a group
user_26391880
•
2
1
1632
timescaledb greatest-n-per-group datetime postgresql sql
Combining multiple rows based on recent values in PostgreSQL
user_78369370
•
2
1
69
aggregate-functions greatest-n-per-group datetime postgresql sql
Trouble getting SQL Server subquery to pick desired results
user_136058700
•
2
1
41
greatest-n-per-group sql-order-by datetime sql-server sql
query to display the student table with students of age more than 18 with unique city
Admin1
•
2
6
11164
subquery greatest-n-per-group where-clause mysql sql
SELECT 1 percent of distinct values
user_12552980
•
3
2
99
sql-server-2008-r2 greatest-n-per-group sql-order-by sql-server sql
How to select rows with the latest date and calculate another field based on the row
user_24588690
•
2
1
83
greatest-n-per-group inner-join datetime mysql sql
Retrieving data from PostgreSQL DB in a more efficient way
user_127819090
•
3
1
229
greatest-n-per-group case datetime postgresql sql
SQL SELECT most recently created row WHERE something is true
user_141756050
•
2
2
57
greatest-n-per-group max inner-join select sql
Hot Questions