Postgres Pro
Downloads
Home   >   mailing lists

Re: Get the max viewd product_id for user_id - Mailing list pgsql-sql

From Mario Splivalo
Subject Re: Get the max viewd product_id for user_id
Date
Msg-id 4CFBC4DB.90101@megafon.hr
Whole thread Raw
In response to Re: Get the max viewd product_id for user_id  (Mario Splivalo <mario.splivalo@megafon.hr>)
Responses Re: Get the max viewd product_id for user_id
List pgsql-sql
Tree view 
On 12/05/2010 05:57 PM, Mario Splivalo wrote:
> The issue in both approaches is that if I have two product_ids that are
> viewed same number of times and share the first place as most viewed
> products by that user, I'll get only one of them (LIMIT 1 OR MAX() can
> only return one row :).
>

And then, to jump again into my own mouth - your approach, Jayadevan, 
correctly gives me both product_id's if they're viewed the same number 
of times.
Mario

pgsql-sql by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: Get the max viewd product_id for user_id
Next
From: Jayadevan M
Date:
Subject: Re: Get the max viewd product_id for user_id