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 <[EMAIL PROTECTED]> 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) >> > > > 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 > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >
