Submitted Questions

  • Difference between Rank and Dense Rank?

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: sm1506

    • Apr 7th, 2006


    Rank:
    1
    2<--2nd position
    2<--3rd position
    4
    5

    Same Rank is assigned to same totals/numbers. Rank is followed by the Position. Golf game ususally Ranks this way. This is usually a Gold Ranking.

    Dense Rank:
    1
    2<--2nd position
    2<--3rd position
    3
    4

    Same ranks are assigned to same totals/numbers/names. the next rank follows the serial number.

    sm1506

    • Apr 7th, 2006

    Rank:12<--2nd position2<--3rd position45Same Rank is assigned to same totals/numbers. Rank is followed by the Position. Golf game ususally Ranks this way. This is usually a Gold Ranking.Dense Ra...

  • How to create a TIME DIMENSION in the Target Database(Oracle)?

    There is a source table in MS-Access within that a column order_date is available. How to create a TIME DIMENSION in the Target Database(Oracle)?

    Motilal

    • Jun 30th, 2006

    Hi Jagadeesh,Can you please mail me with the answer of calling the stored procedure for time dimension.And can have the procedure for time dimension in Oracle..?