StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16544464
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-05-14T13:25:57.203
FavoriteCount
0
LastActivityDate
2013-05-14T13:31:29.677
LastEditDate
2013-05-14T13:31:29.677
LastEditorUserId
15498
OwnerUserId
15498
ParentId
16544173
PostTypeId
2
Score
10
ViewCount
0
LastEditorDisplayName
text
Body
I'm assuming the <code>tsqlt</code> tag was meant to be <code>tsql</code>, and further that this implies that this is for SQL server: <pre><code>;with Numbered as ( select Name,Value, ROW_NUMBER() OVER (ORDER BY Value DESC) as rnDesc, ROW_NUMBER() OVER (ORDER BY Value ASC) as rnAsc from @t ), MixedNumbered as ( select Name,Value, CASE WHEN rnDesc < rnAsc THEN rnDesc ELSE rnAsc END as rnFin, rnAsc, rnDesc from Numbered ) select Name,Value from MixedNumbered order by rnFin,rnDesc </code></pre> This works by finding the row numbers whilst considering the list sorted both highest-to-lowest and lowest-to-highest (in <code>Numbered</code>, <code>rnDesc</code> and <code>rnAsc</code>). We then take the lowest row number that was achieved when considering either of these orderings (<code>MixedNumbered</code>, <code>rnFin</code>). This should then, produce two rows with an <code>rnFin</code> equal to 1, two rows with it equal to 2, and so on; pairing the nth highest and nth lowest rows until we reach the middle of the set. We then use this to sort the final result set - but use the position obtained by considering the values sorted highest-to-lowest (<code>rnDesc</code>) as the tie breaker between each pair of rows with the same <code>rnFin</code> value. This means, for each pair, that the higher valued row will appear first. To reverse the result (lowest first, then highest, the second lowest, second highest, etc), we need only change the final <code>ORDER BY</code> clause to <code>rnFin,rnAsc</code>.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to get the Highest, then the lowest, then the 2nd higest, and then the 2nd lowest value and so on from a table
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USDamien_The_Unbeliever
UserOwnerUserId
1. USDamien_The_Unbeliever
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to get the Highest, then the lowest, then the 2nd higest, and then the 2nd lowest value and so on from a table
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COGreat! This works fine for me... Thank you!!!
 singulars
 PostPostId
 PO
 UserUserId
 USuser1861065

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.