Re: [SQL] Rank

2004-05-05 Thread Martin Knipper
Hey, Muhyiddin A.M Hayat sagte: > > Dear All, > > I Have below table > > id | site_name | point > +---+--- > 1 | Site A|40 > 2 | Site B|90 > 3 | Site D|22 > 4 | Site X|98 > > Would like to calc that Rank for each site, and look like > > > >

Re: [SQL] Rank

2004-05-04 Thread Martin Knipper
Am 04.05.2004 18:47 schrieb Rob: > Martin Knipper wrote: >>Am 04.05.2004 16:11 schrieb george young: >>>On Sun, 2 May 2004 02:22:37 +0800 >>>"Muhyiddin A.M Hayat" <[EMAIL PROTECTED]> threw this fish to the penguins: >>> I Have below table id | site_name | point +---+--

Re: [SQL] Rank

2004-05-04 Thread Rob
Martin Knipper wrote: Am 04.05.2004 16:11 schrieb george young: On Sun, 2 May 2004 02:22:37 +0800 "Muhyiddin A.M Hayat" <[EMAIL PROTECTED]> threw this fish to the penguins: I Have below table id | site_name | point +---+--- 1 | Site A|40 2 | Site B|90 3 | Site D

Re: [SQL] Rank

2004-05-04 Thread Martin Knipper
Am 04.05.2004 16:11 schrieb george young: > On Sun, 2 May 2004 02:22:37 +0800 > "Muhyiddin A.M Hayat" <[EMAIL PROTECTED]> threw this fish to the penguins: > >>I Have below table >> >> id | site_name | point >>+---+--- >> 1 | Site A|40 >> 2 | Site B|90 >> 3 | Site

Re: [SQL] Rank

2004-05-04 Thread george young
On Sun, 2 May 2004 02:22:37 +0800 "Muhyiddin A.M Hayat" <[EMAIL PROTECTED]> threw this fish to the penguins: > I Have below table > > id | site_name | point > +---+--- > 1 | Site A|40 > 2 | Site B|90 > 3 | Site D|22 > 4 | Site X|98 > > Wo

[SQL] Rank

2004-05-04 Thread Muhyiddin A.M Hayat
Dear All,   I Have below table    id | site_name | point+---+---  1 | Site A    |    40  2 | Site B    |    90  3 | Site D    |    22  4 | Site X    |    98    Would like to calc that Rank for each site, and look like        id | site_name | point | rank+---+---

[SQL] Rank

2004-05-04 Thread Muhyiddin A.M Hayat
  Dear All,   I Have below table    id | site_name | point+---+---  1 | Site A    |    40  2 | Site B    |    90  3 | Site D    |    22  4 | Site X    |    98    Would like to calc that Rank for each site, and look like        id | site_name | point | rank+---+-