CODEWITHSUNDEEP
phpmysqlsql
riz
riz

Reputation: 69

how to select values from a table using between condtion

i want a single condition for getting values between dates.

i have a table name user and a column date,i want to fetch the values from database using date condtion.

select sum(visitor) AS V FROM user  WHERE date  < '21-05-2012' AND dDateTime > '11-05-2012' 
select sum(visitor) AS c FROM user  WHERE date  < '21-06-2012' AND dDateTime > '11-06-2012'
select sum(visitor) AS s FROM user  WHERE date  < '21-07-2012' AND dDateTime > '11-07-2012'
select sum(visitor) AS g FROM user  WHERE date  < '21-08-2012' AND dDateTime > '11-08-2012'

i want these four query in a single sql statement

Upvotes: 0

Views: 67

Answers (1)

Arion
Arion

Reputation: 31239

Maybe something like this:

select 
    sum(CASE WHEN date  < '21-05-2012' AND dDateTime > '11-05-2012' THEN visitor ELSE 0 END) AS V, 
    sum(CASE WHEN date  < '21-06-2012' AND dDateTime > '11-06-2012' THEN visitor ELSE 0 END) AS c,
    sum(CASE WHEN date  < '21-07-2012' AND dDateTime > '11-07-2012' THEN visitor ELSE 0 END) AS s,
    sum(CASE WHEN date  < '21-08-2012' AND dDateTime > '11-08-2012' THEN visitor ELSE 0 END) AS g
FROM 
    user

Upvotes: 1

Related Questions