StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
311746
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2008-11-22T20:34:33.900
FavoriteCount
0
LastActivityDate
2008-11-22T20:34:33.900
LastEditDate
LastEditorUserId
0
OwnerUserId
20860
ParentId
311725
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
SQL queries have no looping mechanism. Procedure languages have loops, but queries themselves can only "loop" over data that they find in a table (or a derived table). What I do to generate a list of numbers on the fly is to do a cross-join on a small table of digits 0 through 9: <pre><code>CREATE TABLE n (d NUMERIC); INSERT INTO n VALUES (0), (1), (2), (3), (4), (5), (6), (7), (8), (9); </code></pre> Then to generate 00..99: <pre><code>SELECT n1.d + n2.d*10 AS d FROM n AS n1 CROSS JOIN n AS n10; </code></pre> If you want only 00..57: <pre><code>SELECT n1.d + n2.d*10 AS d FROM n AS n1 CROSS JOIN n AS n2 WHERE n1.d + n2.d*10 <= 57; </code></pre> You can of course join the table for the 100's place, 1000's place, etc. Note that you can't use column aliases in the WHERE clause, so you have to repeat the full expression. Now you can use this as a derived table in a <code>FROM</code> clause and join it to your data table. <pre><code>SELECT n0.d, mytable.value FROM (SELECT n1.d + n2.d*10 + n2.d*100 + n3.d*1000 + n4.d*10000 + n5.d*100000 AS d FROM n AS n1 CROSS JOIN n AS n2 CROSS JOIN n AS n3 CROSS JOIN n AS n4 CROSS JOIN n AS n5) AS n0 LEFT OUTER JOIN mytable ON (n0.d = mytable.key) WHERE n0.d <= (SELECT MAX(key) FROM mytable); </code></pre> You do need to add another <code>CROSS JOIN</code> each time your table exceeds an order of magnitude in size. E.g. when it grows past 1 million, add a join for <code>n6</code>. Note also we can now use the column alias in the WHERE clause of the outer query. Admittedly, it can be a pretty expensive query to do this solely in SQL. You might find that it's both simpler and speedier to "fill in the gaps" by writing some application code.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POSQL query to return rows sorted by key plus empty rows for missing keys
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USBill Karwin
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. 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. 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.