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
SELECT count(*) FROM t WHERE amount != trunc(amount)
Newer Post
Older Post
Home