I looking for Users who might have multiple accounts. The following query from the console works:

```
User.find(:all, :group => :email, :having => "count(*) >1")

```

However, there are some accounts that have an email of 'nil' which I would like to exclude. I tried:

```
User.find(:all, :group => :email, :having => "count(*) >1 and email is not nil")

```

...without success.