[Solved] Show data where the value is after the decimal point

by


You can use FLOOR function to do this. It will round up your numbers, so you can pick only this that are not integers.

create table #t (i decimal(12,6))

insert into #t values (1), (1.1)

select * from #t where FLOOR(i) <> i

solved Show data where the value is after the decimal point