CODEWITHSUNDEEP
mysqlsqlfloating-point
livestrong
livestrong

Reputation: 65

Get floating point numbers from a list

I am working with a table having amount field of type DECIMAL(5,2). The values in the column are

id  amount
1   9.00
2   1.83
3   7.01
4   8.00
5   99.85

I have to get the columns with only that have nonzero after decimal.

From the above list i should get 

id  amount
2   1.83
3   7.01
5   99.85

How should i write the query to get the result?

I am using MySql 5.6.

Upvotes: 3

Views: 82

Answers (1)

Drew
Drew

Reputation: 24949

Just a guess:

SELECT * 
from tblname 
where amount=FLOOR(amount)

Upvotes: 1

Related Questions