Re: special join
Nikolaj Lazic <[email protected]> Mon, 7 Sep 2020 11:54:33 -0000 (UTC)
| Newsgroups | comp.databases.mysql |
|---|---|
| Organization | CARNet, Croatia |
| Message-ID | <[email protected]> |
Dana Mon, 7 Sep 2020 11:52:21 -0000 (UTC), Nikolaj Lazic <[email protected]> napis'o: > Dana Mon, 7 Sep 2020 12:26:14 +0200, Jan Novak <[email protected]> napis'o: >> Hi, >> >> i have a table "server" with auto_increment field ID and a table "ip", >> with a filed "SERVER_ID" corrosponding to "server.ID" >> >> select ip.VALUE as "ip" from server, ip where server.DELETED=0 and >> server.ID=ip.SERVER_ID >> >> If in "ip" table for the server are more then one ip adress are saved, i >> get in my results the server also more then one time listed. >> >> My question is: how can i get only the server with the first IP from the >> ip Table, if more then one ip's saved there. > > group by... count... and then select those >1. > > https://www.w3resource.com/sql/aggregate-functions/count-with-group-by.php https://www.w3resource.com/sql/aggregate-functions/count-having.php