Matt H
Reputation: 3
SQL DB2 Select only rows with data greater than 0 in the fourth and fifth decimal place
I have a column in a DB2 database that has a decimal(19,5). 1523.00000.
Is there a way to run a select query that only pulls rows that have a number other than 0 in the fourth and fifth place? i.e., 1.12345 not 1.12300.
I hope I'm explaining this right, and I tried searching and see a few topics that are close to this but they didn't really answer my questions, so I figured I would ask.
Upvotes: 0
Views: 1219
Answers (1)
Related Questions
- Select numbers with more than 4 decimal places
- How to select only two decimal number without rounding in sql?
- SQL how to filter out values with two decimals
- Need to get a value till precision of 15 digit after decimal in DB2 Query
- WHERE condition to exclude amounts with decimals ending with '0's or '5's
- Remove zeros after two decimal places
- T-SQL select row if one specific column's decimal part is not 0
- DB2 query where first two digits of column are numeric
- SQL Select decimal not 0
- decimal formatting in sql query