IN & BETWEEN Operators1 / 10
IN lets you select data where an attribute matches one of several values from a specified list of values. Try:
SELECT * FROM actors WHERE primary_genre IN ('Slapstick', 'Romantic Comedy');| id | actor_name | primary_genre | debut_year |
|---|---|---|---|
| 1 | Jim Carrey | Slapstick | 1983 |
| 2 | Meg Ryan | Romantic Comedy | 1981 |
| 3 | Adam Sandler | Slapstick | 1987 |
| 4 | Robin Williams | Family Comedy | 1978 |
| 5 | Bill Murray | Dry Comedy | 1976 |
Ctrl+Enter to submit
IN & BETWEEN Operators - Free SQL Practice Online
Practise IN & BETWEEN Operators with 10 free, interactive SQL exercises. You type real queries into your browser and get instant feedback on every answer - no database setup, no install, and no signup. It is a fast, hands-on way to learn SQL online and build query skills you can use at work.