-
Hi Guys, i would like to share with you what is going on in one of my applications.
I got the partition table, each partition has got one month data. i ran some queries on one of the partition, i got the results back with some values. but they were not addind up the total sum.
Here is my table and querys. I would be appriciate your openion.
sql> dec Jun2001
opc varchar2(11),
dpc varchar2(11),
mess_time date,
mess_num number(5),
mcount number(5),
p_id number(3)
Query:
select sum(mcount)
from jun2001
where to_char(mess_time, 'YYMMDDHH') = '01062910'
and dpc = '111.151.101'
or opc = '111.151.101'; --- BAD RESULTS
select sum(mcount)
from jun2001
where to_char(mess_time, 'YYMMDDHH') = '01062910'
and dpc = '111.151.101';
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|