how to select values from a table using between condtion

Question

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

i am using these four query i want to make this four query in a single statement — riz
– riz, Commented Jun 5, 2012 at 7:18

Arion · Accepted Answer · 2012-06-05 07:23:41Z

1

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

answered Jun 5, 2012 at 7:23

Arion

31.3k10 gold badges74 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to select values from a table using between condtion

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related