Hi DB2 gurus,
I have some issues when running this queries which are suposed to return
the same num of rows .
this is a multipartioning db running with DB2 UDB fix Pack 5 the last
release:

NOTE :
entryid=partitioning key for this table




db2 "SELECT count (*) FROM bc .tab_63 alias1 > WHERE alias1.lower <=
200.0 and 200.0 <= alias1.upper and > alias1.ellipticity > 0.5" > >
1 > -----------
> **8001**
>

-db2 "SELECT entryID FROM bc.tab_63 alias1
WHERE alias1.lower <= 200.0 and 200.0 <= alias1.upper and
alias1.ellipticity > 0.5 "

x'1400F600F7F49E7E'
x'1700F5F4E6245057'
x'1700F6010D92C051'
x'1E00F601140B80F6'

*18540 record(s) selected.*



> 1 record(s) selected

db2 "SELECT entryID FROM bc.tab_63 alias1 WHERE
> alias1.lower <= 200.0 and 200.0 <= alias1.upper and
alias1.ellipticity > > > 0.5 group by (entryid) >
x'2900F60080442F3D' > x'2900F60080442F5A' >
> **8001 record(s) selected.*


NOTE :
entryid=partitioning key for this table



DB2 & UDB email list listserv db2-l LazyDBA home page