SELECTING DEC 8 2. value from DB ? ( Decimal places contains some value )
There is a table in which one field is of type DEC 8 2.
I have to select all records for which this field can have decimal places( I mean decimal places have some value instead of '00' ).
How to write my SELECT stmt ?
For eg 12.00 , 657.00, 123.12...
I need to SELECT only 123.12 value .
Could you please suggest me how can I SELECT those values in my SELECT stmt ?