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]
*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]
*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
