Re: Fwd: Silly question about numbering of rows? - Mailing list pgsql-novice

On Tuesday 13 March 2001  3:56 pm, you wrote:
> Have you missed one and after  "make=2" ?

Hi Vijay...yes, of course, you're right. I'd like to say it's a 'cut and
paste' error and blame the computer...but I'm afraid I typed it in by hand.

(The question still stands, though...)

>
> Vijay
>
> Ken Corey wrote:
> > I have a table like this:
> >
> >         id |      make | model | year  | value
> > ---------+-----------+--------+-------+-------
> >        57 |            2 |        0 |       4 |  4750
> >        57 |            2 |        3 |       4 |  4750
> > I want to be able to select from this table like this:
> > select
> >         <numbering magic>, id, value
> >   from
> >         mytable
> >  where
> >         make=2
> >         model=3
> >         and year=5
> >  order by score desc;

--
Ken Corey, CTO    Atomic Interactive, Ltd.   ken.corey@atomic-interactive.com