yes, I am picking up the specific transaction (order_id) so that I can pickup the create_timestamp and sort it descending.
that will list me those users who did transaction more than 500 in the least time.
then I can give discount for top 10 users
expected output: user_id, create_timestamp(desc) with limit 10.
then I will give discount of 10%, 9%, .. etc.
if you know ageing credit. its just like that.
On Sat, Nov 8, 2008 at 2:30 AM, Frank Bax
<fbax@sympatico.ca> wrote:
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)
Frank
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
