Questions regarding the common SQL problem selecting records holding the group-wise maximum of a certain column. Example: "For each article, find the dealer or dealers with the most expensive price."
Questions tagged [groupwise-maximum]
212 questions
-3
votes
1 answer
MySQL View in place of subquery does not return the same result
The query below is grabbing some information about a category of toys and showing the most recent sale price for three levels of condition (e.g., Brand New, Used, Refurbished). The price for each sale is almost always different. One other thing -…
Kris
- 201
- 1
- 8
-3
votes
1 answer
SQL: Get most recent maximum entry
Anyone know how to get the most RECENT, maximum score from this table:
----------------------------------------
|id |game_id |level |score |date |
----------------------------------------
|1 |0 |1 |90 |1391989720 |
|1 |0 …
user3241112
- 69
- 3
- 8