Your plan looks OK. As Amr said, try to find the offending users.
From: Amr Awadallah [mailto:[email protected]] Sent: Thursday, July 02, 2009 5:53 PM To: [email protected] Subject: Re: distinct with union all make sure you don't have any leading or trailing spaces (or special characters) for the usernames being extracted. also to debug, try to do a select username, count(1) then group by username -- amr Rakesh Setty wrote: Yes, I am getting duplicate usernames. ________________________________ From: Namit Jain [mailto:[email protected]] Sent: Thursday, July 02, 2009 1:25 PM To: [email protected]<mailto:[email protected]> Subject: RE: distinct with union all Are you getting duplicate usernames ? From: Rakesh Setty [mailto:[email protected]] Sent: Thursday, July 02, 2009 12:37 PM To: [email protected]<mailto:[email protected]> Subject: distinct with union all Hi, I have a query like select distinct username from (select user as username from page_views pv union all select name as username from users u) ur; But I see that result is not actually distinct. Am I missing something here? Thanks, Rakesh
