Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with greatest-n-per-group
Search options not deleted
user 83663
Use this for problems that involve returning one or more rows from each group in a data set. Despite the name, this tag is suitable for *minimum-* and *maximum-* per group queries.
0
votes
1
answer
115
views
How do I write this query?
I have a table that looks like this:
CREATE TABLE `message` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) unsigned NOT NULL,
`grp_id` int(10) unsigned NOT NULL,
`body …
- 305
2
votes
0
answers
172
views
Groupwise max then join
I have a votes table that has many subitems. I have a subitems action table that records what action was performed by which user on which group, on which subitem, on which vote
Users can either cast/ …
- 305
3
votes
1
answer
94
views
What indexes to use for GroupWise max
I have a user table and group table, and a many to many relationship between them.
I have a vote table (one to many relation between group and vote) And a subitem table (one to many between vote and …
- 305