sql - MySql sorting float data type -


hi guys im having problem sorting column named "change" reserved word has data type of "float" in database.

tried different ways still cant it.

"select * data order cast('change' signed) desc"; "select * data order abs(change) desc"; "select * data order abs(change - float) desc"; "select cast(change float) abc* data order abc desc"; 

i tried lots of different combinations still no luckenter image description here

heres picture of sample database thank in advance!

use ticks

order `change` desc 

each rdbms has different way of handling reserved words. mysql uses ticks : `

the error got has nothing casting .


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -