SELECT TOP 10 Score FROM Posts ORDER BY Score DESC /* ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Query 1 [2.2.1. The top 10 posts by score]
SELECT TOP 10 Score
--Id,PostTypeId,Score,ViewCount,Body,OwnerUserId,OwnerDisplayName,Title,Tags
FROM Posts
ORDER BY Score DESC


/*
-- Query 2 [2.2.2. The top 10 users by post score]

SELECT TOP 10 OwnerUserId,OwnerDisplayName,PostTypeId,Score
--Id,PostTypeId,Score,ViewCount,Body,OwnerUserId,OwnerDisplayName,Title,Tags
FROM Posts
ORDER BY Score DESC
*/

-- Query 3 [2.2.3. The number of distinct users, who used the word “cloud” in one of their posts]

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results