Post reply

edit view by adding squence number

  • September 14, 2008 at 6:21 am

    #94129

    i have view with 2 columns name and salary i want to add a new column with id name the value of this column will changed every 3 rows one time

    Example:

    id name salary

    1 ma 500

    1 hh 300

    1 uu 200

    2 ff 100

    2 rr 500

    2 tt 111

    3 re 333

    ---

    --

    -

    thank you for help

  • September 14, 2008 at 7:34 am

    #871534

    Check out NTILE() function.

    N 56°04'39.16"
    E 12°55'05.25"

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply