mocanu silviu wrote: > salut! >se da un tabel mysql de genul : >+----------------|---------+ >| id | tool | >+----------------|----------| >| 25 | ABC | >| 25 | DEF | >| 24 | ABC | > >cum ar trebui sa arate un select care sa returneze acele "id" pentru >care acelasi exista si linii cu tool="ABC" si tool="DEF" ? > >experimental s-a constatat ca nu merge varianta de mai jos: >mysql> select distinct ID from tools where tool like '%ABC%' and tool >like '%DEF%'; >Empty set (0.01 sec) > > > > >--- >Detalii despre listele noastre de mail: http://www.lug.ro/ > > > > > Raspunsul corect (si logic) era:
mysql> SELECT ID,tool, COUNT(tool) FROM tools WHERE (tool='abc' OR tool='def') GROUP BY tool HAVING `count(tool)`=2; +-------------+------+-------------------+ | ID | tool | COUNT(tool) | +-------------+------+------------------+ | 25 | def | 2 | +-------------+------+------------------+ 1 row in set (0.00 sec) Multumesc celor care mi-au raspuns, chiar daca au facut-o fara sa inteleaga intrebarea! --- Detalii despre listele noastre de mail: http://www.lug.ro/
