Re: [SQL] SQL syntax I've been unable to figure out....

2008-12-25 Thread Rodrigo E. De León Plicet
2008/12/25 Karl Denninger : > Assuming a table containing: > > name text > address text > uri text > > I wish to run a query that will return those rows where: > > ("name" is not null) AND (distinct) (uri is the same for two or more entries > AND name is different between the two entries)) > > Exam

[SQL] SQL syntax I've been unable to figure out....

2008-12-25 Thread Karl Denninger
for the following Assuming a table containing: name text address text uri text I wish to run a query that will return those rows where: ("name" is not null) AND (distinct) (uri is the same for two or more entries AND name is different between the two entries)) Example data: george who 1 sa