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

by

[ad_1]

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

[ad_2]

solved Show data where the value is after the decimal point