1 Reply Latest reply: Jun 27, 2012 12:45 AM by Tresesco B RSS

    rowno() is not working?

      Hi,

       

      I knew it's a simple script.. but stil it's not working.. any one can explain me clearly pls?

       

      This one is "working" with condition where rowno()<3;

      t1:

      LOAD * INLINE [

          name.1, id.1

          mani, 1

          maran, 2

          nice, 3

          usa, 4

          ram, 5

          uma, 6

          mani,90

       

      ] WHERE rowno()<3;

       

       

      This one is "not working" with condition where rowno()>3;

       

      t2:

      LOAD * INLINE [

          name.2, id.2

          mani, 1

          maran, 2

          nice, 3

          usa, 4

          ram, 5

          uma, 6

          mani,90

       

      ] WHERE rowno()>3;

       

       

      This one is "not working" with condition where rowno()=3;

      t3:

      LOAD * INLINE [

          name.3, id.3

          mani, 1

          maran, 2

          nice, 3

          usa, 4

          ram, 5

          uma, 6

          mani,90

       

      ] WHERE rowno()=3;

       

      The thing is "The function is not working if i use ">" and "=" symbol..

       

      Pls help me with this:-)