title: Sybase Alternative for DENSE_RANK() OVER (PARTITION BY
body: <p>I have a below SQL query, need to convert it into Sybase.</p>
  
  <pre><code>SELECT prd_name, DENSE_RANK() OVER (PARTITION BY prd_cat ORDER BY createddt) FROM product
  </code></pre>
  
  <p>Table Script:  </p>
  
  <pre><code>CREATE table product(prd_name varchar(10),
                       prd_cat varchar(10), 
                       createddt datetime)
  INSERT INTO product values('Product 1', 'Toy', CONVERT(DATE,'2017-05-30'))
  INSERT INTO product values('Product 2', 'Toy', CONVERT(DATE,'2017-05-31'))
  INSERT INTO product values('Product 3', 'Toy', CONVERT(DATE,'2017-05-31'))
  INSERT INTO product values('Product 4', 'Toy1', CONVERT(DATE,'2017-05-29'))
  </code></pre>
  
  <p>Version: Adaptive Server Enterprise/15.7</p>