Issue
example: i have a number=143.42 , i want to get "4" which is locate 2 place before decimal point. what SQL command should i use? i still new in SQL, don't roast me too hard.
Solution
You could do it with some simple math
SELECT 143.42 div 10 % 10;
Answered By - Diadistis Answer Checked By - Marie Seifert (PHPFixing Admin)
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.