On Thu, May 12, 2011 at 1:45 PM, Thomas Kellerer wrote:
> Nguyen,Diep T wrote on 12.05.2011 03:59:
>
>>
>> Any help would be appreciated.
>>
>
> SELECT id,
> date,
> score_count,
> row_number() over (partition by id order by date desc) as order_value
> FROM your_table
>
>
>
Or t
Nguyen,Diep T wrote on 12.05.2011 03:59:
Each ID can have different number of score counts.
My goal is to add column "order", which shows the order of the values
in column "date" in descendant order for each property. The expected output
will look like this:
id | date | score
Hi all,
I have this table
id | date | score_count
+--+-
13 | 1999-09-16 | 4
13 | 2002-06-27 | 4
13 | 2006-10-25 | 4
13 | 2010-05-12 | 4
65 | 2002-07-18 | 3
65 | 2004-08-05 | 3
65 |
Tony Capobianco wrote:
We are converting from Oracle to Postgres. An Oracle script contains
this line:
select replace(firstname,'"'), memberid, emailaddress from members;
in an effort to replace the " with nothing. How can I achieve the same
result with Postgres?
Here's the Postgres error
On 12/05/11 00:19, Grzegorz Szpetkowski wrote:
Is there any "proper", standard ordering that I can assume for sure ?
Maybe PostgreSQL 8.4/9.0 versions have strict ordering and older
versions are using mixed ordering depends on something I don't know (I
am just guessing).
Queries do not have any
