SET ROWCOUNT 10 SELECT * FROM Comments c SET ROWCOU...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SET ROWCOUNT 10

SELECT  *

FROM Comments c



SET ROWCOUNT 10

SELECT  *

FROM Posts P


SET ROWCOUNT 10
SELECT postid, COUNT(*) as commentsQuantity FROM comments GROUP BY postid ORDER BY commentsQuantity Desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results