On Tue, May 20, 2008 at 11:44 PM, Karl Denninger <[EMAIL PROTECTED]> wrote:
> .... assuming the following schema: > > create table access (name text, address ip) > > I want to construct a SELECT statement which will return ONLY tuples > containing IP and name pairs IF there is an IP that has two or more NAMEs > associated with it. > > I've not figured out how to do this; I can get a list of all IPs and names > ordered by IP, which I could then parse with a different program (e.g. > "Select name, address from access order by address"), but the idea of course > is to do it with one SELECT statement and return only rows that have > multiple names listed for a given IP. > > try this: select ip, name from access where ip in ( select ip from access group by ip having count(name) > 2); heven't execued it, so may need some coaxing. Let me know the results. Best regards, -- [EMAIL PROTECTED] [EMAIL PROTECTED] gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com Mail sent from my BlackLaptop device
