Re: Fwd: Silly question about numbering of rows?

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(dot)corey(at)atomic-interactive(dot)com