SELECT c.postid ,c.text ,ROW_NUMBER () OVER (PARTITION BY...


Please login or register to vote for this query.

(click on this box to dismiss)

Drupal Answers

Q&A for Drupal developers and administrators

SELECT c.postid 
  ,ROW_NUMBER () OVER (PARTITION BY c.postid ORDER BY c.creationdate DESC) AS rn
  FROM comments c

Enter Parameters

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