josep porres escreveu:
maybe this?
select value, max(id) as id, max(order_field) as order_field
from mytable
group by value
order by 3
Wrong. For the op data you will obtain tuples not in original relation.
bdteste=# SELECT * FROM foo;
id | value | order_field
+---+-
An: Stanislav Raskin
Cc: pgsql-general@postgresql.org
Betreff: Re: [GENERAL] SELECT DISTINCT ON and ORDER BY
maybe this?
select value, max(id) as id, max(order_field) as order_field
from mytable
group by value
order by 3
2008/3/28, Stanislav Raskin <[EMAIL PROTECTED]>:
Hello eve
On Fri, 28 Mar 2008, Sam Mason <[EMAIL PROTECTED]> writes:
> On Fri, Mar 28, 2008 at 01:12:49PM +0100, Stanislav Raskin wrote:
>> The result in this case should be:
>>
>> id value order_field
>> 3 10 1
>> 5 12 2
>> 45 8
Yet another lame solution:
test=# SELECT max(id) AS
maybe this?
select value, max(id) as id, max(order_field) as order_field
from mytable
group by value
order by 3
2008/3/28, Stanislav Raskin <[EMAIL PROTECTED]>:
>
> Hello everybody,
>
>
>
> I have a table like this one:
>
>
>
> id value order_field
>
> 1 103
>
> 2
On Fri, 28 Mar 2008, Sam Mason <[EMAIL PROTECTED]> writes:
> On Fri, Mar 28, 2008 at 01:12:49PM +0100, Stanislav Raskin wrote:
>> The result in this case should be:
>>
>> id value order_field
>> 3 10 1
>> 5 12 2
>> 45 8
>
> SELECT id, value
> FROM (
> SELECT DISTINC
On Fri, Mar 28, 2008 at 01:12:49PM +0100, Stanislav Raskin wrote:
> id value order_field
> 1 10 3
> 2 12 4
> 3 10 1
> 45 8
> 5 12 2
>
> Hence selecting rows with distinct values, but primarily ordered by
> order_field, instead of value, which is requires by DI
Hello everybody,
I have a table like this one:
id value order_field
1 103
2 124
3 101
4 5 8
5 122
What I want to do, is to do something like
SLECT DISTINCT ON (my_table.value)
my_
