A bozo's blog
Thursday, October 12, 2017
PostgreSQL: Find numeric rows w/o digit after decimal point
Source:
Fetch records that are non zero after the decimal point in PostgreSQL
1
SELECT
count
(*)
FROM
t
WHERE
amount != trunc(amount)
Newer Post
Older Post
Home