From: | Ken Corey <ken(dot)corey(at)atomic-interactive(dot)com> |
---|---|
To: | Vijay Deval <deval(at)giaspn01(dot)vsnl(dot)net(dot)in> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Fwd: Silly question about numbering of rows? |
Date: | 2001-03-13 15:55:48 |
Message-ID: | 0103131555481C.06836@kenlinux.bithub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)corey(at)atomic-interactive(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | mikhail malamud | 2001-03-13 16:41:28 | RE: add primary key |
Previous Message | Dax Duskin | 2001-03-13 15:53:48 | Re: array column problem |