SQL Statement to Fine Non Decimal in Mysql -


i have sql statement in mysql db find non decimal number decimal number. data this.

  table: products  productid 10.20 12.15 136.42  need results below.  productid 10 12 136   ideas? 

i suggest use floor () .

select floor(productid) table 

Comments

Popular posts from this blog

SPSS keyboard combination alters encoding -

Socket.connect doesn't throw exception in Android -

iphone - How do I keep MDScrollView from truncating my row headers and making my cells look bad? -