StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16033487
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-04-16T09:34:04.913
FavoriteCount
0
LastActivityDate
2013-04-16T09:34:04.913
LastEditDate
LastEditorUserId
0
OwnerUserId
1998124
ParentId
16008637
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
You might use this query - the purpose is to get [n] resaleids for each shipwynum, where [n=2] is <pre><code>SELECT (SUBSTRING_INDEX(GROUP_CONCAT(CONVERT(resaleid, CHAR(8)) ORDER BY resaleid DESC), ',', 2)) AS ID FROM resale WHERE deleted = 'N' GROUP BY shipwynum </code></pre> Please not that GROUP_CONCAT result is truncated to max len 1024 (group_concat_max_len). And this might have performance issue so please feel free to update and optimize as needed. Other suggestion would be to set a rank but not how will work this for you. You can check rank : <a href="http://www.oracle-base.com/articles/misc/rank-dense-rank-first-last-analytic-functions.php#rank" rel="nofollow">http://www.oracle-base.com/articles/misc/rank-dense-rank-first-last-analytic-functions.php#rank</a> Hope this helps. <pre><code>SELECT re.recdat, re.resaleid, IF (re.benownsal != '', owsal.ownshortnam, if ((re.grptypsal != '' && re.bogrpidsal != ''), if (bosal.bogrpshort != '', bosal.bogrpshort, bosal.bogrpnam), cou1.nation)) as seller, IF (re.benownpur != '', owpur.ownshortnam, if ((re.grptyppur != '' && re.bogrpidpur != ''), if (bopur.bogrpshort != '', bopur.bogrpshort, bopur.bogrpnam), cou.nation)) as buyer, re.benownpur, re.grptyppur, re.bogrpidpur, re.statuscod, re.showinob, re.benownsal, re.grptypsal, re.bogrpidsal FROM resale AS re left join owner as owpur on owpur.ownwynum = re.benownpur left join owner as owsal on owsal.ownwynum = re.benownsal left join bogroup as bopur on bopur.bogrpid = re.bogrpidpur left join bogroup as bosal on bosal.bogrpid = re.bogrpidsal left join country as cou on cou.coucod = re.buynation left join country as cou1 on cou1.coucod = re.selnation WHERE LOCATE (re.resaleid, ( SELECT GROUP_CONCAT(it.resaleid) AS ids FROM ( SELECT (SUBSTRING_INDEX(GROUP_CONCAT(CONVERT(resaleid, CHAR(8)) ORDER BY resaleid DESC), ',', 2)) AS ID FROM resale WHERE deleted = 'N' GROUP BY shipwynum ) it )) <> 0 /* AND re.deleted = 'N' */ order by re.saltyp desc, re.recdat </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POmysql query grouping logic
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAnda Iancu
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.