devxlogo

Find out Whether a Value Exists in a List of Values

Find out Whether a Value Exists in a List of Values

You can use a normal SELECT query joined with a bunch of AND statements to determine if a certain value exists, but this can become cumbersome and tedious. Enter the IN statement. You could use it like this:

SELECT *  FROM    TABLE WHERE STUDENTID  IN(STU123,STU456,STU789,STU1003,STU10)

devx-admin

Share the Post: