Sql Statement using Where clause with multiple values

Squeezing more out of WHERE

Layering conditions with AND

IN is great, but how about painting with more colors? Combine filters using AND:

SELECT *
FROM table
WHERE column IN ('Value1', 'Value2', 'Value3') 
-- The IN Crowd
AND another_column = 'AnotherValue'; 
-- The AND Band


Adding AND imposes additional filtration layers along with the IN operator.

Going unique with DISTINCT

DISTINCT is your best friend to fetch unique entries, especially when dealing with joined data or aggregates:

SELECT DISTINCT column
FROM table
WHERE column IN ('Value1', 'Value2', 'Value3');
-- Unique, DISTINCTly so


With DISTINCT, you ensure each returned value is as unique as a unicorn.

Juggling with ranges using BETWEEN

Instead of discrete values, what if you're dealing with ranges? That's when BETWEEN comes in:

SELECT *
FROM table
WHERE column BETWEEN 'StartValue' AND 'EndValue';
-- Between a rock and a hard place


BETWEEN gets you rows where column value is chilling between your specified range.

Deep diving into advanced tactics

Making friends with JOINs

INNER JOIN enters the scene when your query crosses multiple tables:

SELECT songs.SongName
FROM songs
INNER JOIN artists ON songs.ArtistID = artists.ID
WHERE artists.Name IN ('Artist1', 'Artist2', 'Artist3');
-- The band is back together!


The above links two tables and filters songs based on a list of artist names.

Giving order with GROUP BY

When it's more about a harmonious group than individual row-band members:

SELECT SongName, COUNT(DISTINCT PersonName) as Contributors
FROM songs
GROUP BY SongName -- Stars only shine in the dark
HAVING COUNT(DISTINCT PersonName) > 1;
-- It takes two to tango.


The GROUP BY alongside HAVING clause helps in cases like finding songs with multiple contributors.

Jamming with stored procedures

Security and reusability gets into the groove with parameterized stored procedures, especially when dealing with user inputs:

CREATE PROCEDURE FilterByValues(
    @Value1 VARCHAR(255), -- You
    @Value2 VARCHAR(255), -- Me
    @Value3 VARCHAR(255)  -- Us
)
AS
BEGIN
    SELECT *
    FROM table
    WHERE column IN (@Value1, @Value2, @Value3);
    -- We're in this together! 
END


Now, you can replay the procedure with different values, without re-writing your hit query.