1 Reply Latest reply: Apr 28, 2017 6:08 AM by Shiva Nagesh RSS

    SQL to QV convert

    Priya R

      Hi Community,

       

      I have below query and need to convert to QV.

      SELECT

      row_number() over(partition by contract_ref order by contract_ref) AS "Row #",contract_ref

      from Table;

       

      Data would come like this

      contract_ref - Row #

      1 - 1

      1 - 2

      2 - 1

      3 - 1

      3 - 2

      3 - 3

      4 - 1

       

      I have to create dimension for "Row #", pls can someone share ideas.

       

      _priya