Ad:

MySQL Discussion Thread
Unsolved
Views: 716

Jun 8th, 2009

2 slelect statement in 1 query..HOW?

Expand Post »

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:

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:

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.

Similar Threads

SQL statement to query user input?? in MS Access and FileMaker Pro
how to delete duplicate record in a table by using SQL query in MS SQL
If Statement Query in PHP
SQL statement help! in Visual Basic 4 / 5 / 6
SQL query program to edit records in MySQL

jegham

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2009

Permalink

Jun 8th, 2009

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

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

verruckt24

Reputation Points: 485

Solved Threads: 89

Posting Shark

Offline

944 posts
since Nov 2008

Permalink

Jun 8th, 2009

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

Mean something like this?

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

pritaeas

Sponsor

Featured Poster

Reputation Points: 550

Solved Threads: 730

Bite my shiny metal ass!

Offline

4,177 posts
since Jul 2006

Permalink

Jun 11th, 2009

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

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

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

Thanks

Tulsa

Reputation Points: 13

Solved Threads: 15

Junior Poster in Training

Offline

77 posts
since May 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: Compare 2 time values to get an approximate result

Next Thread in MySQL Forum Timeline: Mysgl error please help

DaniWeb Message

Cancel Changes

User Name
Password