Where clause selecting rows not fulfilling criterion

[pgk]

Hi,

The following is the query that I used;

select distinct rate ,eff_rcbl_tier_level from TRADE where eff_rcbl_tier_level='D' group by eff_rcbl_table_id

The result the query returned:



rate eff_rcbl_tier_level
------------------ -------------------
0.0000000 D
0.0000000 X
223.6000000 X

Please note that it is returning rows with 'X' when th e where clause specifies a 'D'.

Can someone throw some light on this?

Thanks in advance.


Hope it helps. Let me know what happens.
With regards,
PGK

 

[sybaseguru]

PGK,

can you please do a sp_help on TRADE and send the output please. Also it will help what the values you put in for eff_... when you inserted records.

 

[pgk]

Hi,
I will have to post the sp_help o/p later since I don't have access to it right now. But I found out something: if I include the eff_rcbl_tier_level also in the GROUP BY clause it works perfectly.

So how really does it arrive at the final o/p?

Thanks in advance

Hope it helps. Let me know what happens.
With regards,
PGK