Skip site navigation (1) Skip section navigation (2)

Re: need help in building a query

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: need help in building a query
Date: 2008-11-07 21:00:40
Message-ID: 4914AC78.8050805@sympatico.ca (view raw or flat)
Thread:
Lists: pgsql-sql
Devil™ Dhuvader wrote:
>   its like sum up entries of each user in order table backwards (i.e 
> from last entry to the first) and find the entry that has sum > $500.
> If there is some user who didnt even make 500 till now in my shop return 
> the first date of transaction/order .
> 
> ex:
> Orders(order_id, user_id, amount_paid, create_timestamp)
> values:
> (1, 1, 100, 1)
> (2, 1, 300, 2)
> (3, 2, 100, 2)
> (4, 2, 100, 3)
> (5, 1, 100, 4)
> (6, 1, 200, 5)
> (7, 2, 150, 5)
> 
> for user 1: the order_id = 2
> for user 2: the order_id = 3 (coz he couldnt make 500)


I might also take a crack at the SQL if I understood the question; but I 
still don't know what you want.  You're initial question indicated you 
were trying to calculate the proper discount for each customer.  This 
example mentions neither customers nor discounts at all and appears to 
be looking for a specific transaction instead.

Frank

In response to

Responses

pgsql-sql by date

Next:From: Devil™ DhuvaderDate: 2008-11-08 16:57:12
Subject: Re: need help in building a query
Previous:From: Osvaldo KussamaDate: 2008-11-07 20:51:03
Subject: Resp.: need help in building a query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group