Stack Exchange
log in help

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

0

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 
  ,c.text 
  ,ROW_NUMBER () OVER (PARTITION BY c.postid ORDER BY c.creationdate DESC) AS rn
  FROM comments c
fork query

Enter Parameters

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