I have a column that is currently a floating-point number and I need to check if all the values in the column are i开发者_Go百科ntegers. What's the easiest way to do this?
SELECT COUNT(*) FROM yourtable WHERE ceil(yourcolumn) != yourcolumn
If the count > 0 then there are non-integer values.
And to specifically find the records that are not integers...
SELECT * from yourtable WHERE col % 1 != 0;
精彩评论