0

Please login or register to vote for this query.

(click on this box to dismiss)

Just for myself

Q&A for Ubuntu users and developers

-- Test Query
-- Just for myself

WITH Questions AS (
SELECT TOP 10
Id AS QuestionId
FROM Posts
WHERE PostTypeId=1
ORDER BY NEWID()
)
SELECT 
Posts.Id AS ResponseId, Questions.QuestionId, Score, OwnerUserId, Users.Reputation
FROM Posts
INNER JOIN Questions ON Questions.QuestionId=Posts.ParentId
INNER JOIN Users ON Users.Id=Posts.OwnerUserId

fork query

created feb 8 11 anonymous