MySQL

2 slelect statement in 1 query..HOW?

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2009

Posts: 1

Reputation: jegham is an unknown quantity at this point

Solved Threads: 0

jegham

Offline

Newbie Poster

2 slelect statement in 1 query..HOW?

Jun 8th, 2009

Hi all,

I am fairly new when it comes to SQL... and i would like some help

I would like to run 2 select statements in the same time...in order to get my results in a table with 2 columns and 2 rows that shows me the result of my queries

1st query:

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT  count(serviceid)
FROM serviceslog
WHERE serviceid='3'
AND partition NOT LIKE '%test%'
AND component NOT LIKE '%test%'
AND component NOT LIKE '%do not bill%'
AND occurence BETWEEN '2009-05-01 05:00:00' AND '2009-06-01 04:59:59'
GROUP BY serviceid;
select  count(serviceid)
from serviceslog
where serviceid='3'
and partition not like '%test%'
and component not like '%test%'
and component not like '%do not bill%'
and occurence between '2009-05-01 05:00:00' and '2009-06-01 04:59:59'
group by serviceid;

2nd query:

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
SELECT  count(serviceid)
FROM serviceslog
WHERE serviceid='3'
AND partition NOT LIKE '%test%'
AND component NOT LIKE '%test%'
AND component NOT LIKE '%do not bill%'
AND occurence BETWEEN '2009-05-01 05:00:00' AND '2009-06-01 04:59:59'
GROUP BY serviceid;
select  count(serviceid)
from serviceslog
where serviceid='3'
and partition not like '%test%'
and component not like '%test%'
and component not like '%do not bill%'
and occurence between '2009-05-01 05:00:00' and '2009-06-01 04:59:59'
group by serviceid;

Any help would be appreciated.

Last edited by peter_budo; Jun 8th, 2009 at 10:40 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Nov 2008

Posts: 823

Reputation: verruckt24 is a jewel in the rough

Solved Threads: 73

verruckt24 verruckt24 is offline

Offline

Practically a Posting Shark

Re: 2 slelect statement in 1 query..HOW?

Jun 8th, 2009

It is unclear what you exactly want to achieve. Bot hof your queries are identical.

Get up every morning and take a look at the Forbes' list of richest people. If your name doesn't appear.... GET TO WORK !!!

•

Join Date: Jul 2006

Posts: 827

Reputation: pritaeas will become famous soon enough

Solved Threads: 135

pritaeas

Offline

Practically a Posting Shark

Re: 2 slelect statement in 1 query..HOW?

Jun 8th, 2009

Mean something like this?

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
SELECT  '1' as rownum, count(serviceid) as id
FROM serviceslog
WHERE serviceid='1'
AND partition NOT LIKE '%test%'
AND component NOT LIKE '%test%'
AND component NOT LIKE '%do not bill%'
AND occurence BETWEEN '2009-05-01 05:00:00' AND '2009-06-01 04:59:59'
GROUP BY serviceid
 
UNION
 
SELECT '2' as rownum, count(serviceid) as id
FROM serviceslog
WHERE serviceid='3'
AND partition NOT LIKE '%test%'
AND component NOT LIKE '%test%'
AND component NOT LIKE '%do not bill%'
AND occurence BETWEEN '2009-05-01 05:00:00' AND '2009-06-01 04:59:59'
GROUP BY serviceid
select  '1' as rownum, count(serviceid) as id
from serviceslog
where serviceid='1'
and partition not like '%test%'
and component not like '%test%'
and component not like '%do not bill%'
and occurence between '2009-05-01 05:00:00' and '2009-06-01 04:59:59'
group by serviceid

union
 
select '2' as rownum, count(serviceid) as id
from serviceslog
where serviceid='3'
and partition not like '%test%'
and component not like '%test%'
and component not like '%do not bill%'
and occurence between '2009-05-01 05:00:00' and '2009-06-01 04:59:59'
group by serviceid

"If it is NOT source, it is NOT software."
-- NASA

•

Join Date: May 2009

Posts: 77

Reputation: Tulsa is an unknown quantity at this point

Solved Threads: 15

Tulsa

Offline

Junior Poster in Training

Re: 2 slelect statement in 1 query..HOW?

Jun 11th, 2009

hi
If you want all same fields for different id than you can use 'in ' with where clause.

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
SELECT  count(serviceid) as id
FROM serviceslog
WHERE serviceid IN ('1','2')
AND partition NOT LIKE '%test%'
AND component NOT LIKE '%test%'
AND component NOT LIKE '%do not bill%'
AND occurence BETWEEN '2009-05-01 05:00:00' AND '2009-06-01 04:59:59'
GROUP BY serviceid
select  count(serviceid) as id
from serviceslog
where serviceid in ('1','2')
and partition not like '%test%'
and component not like '%test%'
and component not like '%do not bill%'
and occurence between '2009-05-01 05:00:00' and '2009-06-01 04:59:59'
group by serviceid