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) rn 
  FROM comments c

Enter Parameters

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