where
> rowid in (select rowid from fruits where type = f.type order by
> price desc limit 1)
>
> ?
>
> No need for the 'AS' there.
>
> /Jonas
>
> On Tue, Dec 9, 2008 at 12:54 AM, Hariyanto Handoko <[EMAIL PROTECTED]> wrote:
>> I want to get one result fr
ith the highest price within
> one value of 'type' (I have difficulty saying what I mean in english.)
>
> However, the longer i look at the statement, the less sense it makes to
> me. Perhaps Hariyanto Handoko would like to post what the statement is
I still sqlite 2.8.17. Can someone help me to convert this sql?
tx
select f.type, f.variety, f.price
from
fruits f
where
rowid in (select rowid from fruits where type = f.type order by
price desc limit 1)
order by f.type asc, f.price desc;
___
3 matches
Mail list logo