Opereta IN ya SQL

Opereta IN

Opereta IN inaruhusiwa kutumia mbalimbali ya thamani katika kigeuko WHERE.

Inayofaa kwa SQL IN

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...)

Tablica ya asili (inaonyeshwa kwenye mifano):

Jina la tablica ya Persons:

Id LastName FirstName Adress City
1 Adams John Oxford Street London
2 Bush George Fifth Avenue New York
3 Carter Thomas Changan Street Beijing

Mfano wa opereta IN

Sasa, tunataka kutumia tablica ya juu kwa wengi wa jina la kifamilia ni Adams na Carter:

Tunaweza kutumia uamuzi wa SELECT hii:

SELECT * FROM Persons
WHERE LastName IN ('Adams','Carter')

Matokeo ya mafanikio:

Id LastName FirstName Adress City
1 Adams John Oxford Street London
3 Carter Thomas Changan Street Beijing