bunho : varchar(10)
| bunho |
| 100 |
| 78 |
| 1 |
| 99 |
| . . . |
SELECT MAX(bunho) FROM temp_tbl;<결과값>
| MAX |
| 99 |
"100"을 기대했으나 99가 나온다.
숫자로 형변환하는 CAST 사용해서 MAX값 가져옴.
SELECT MAX(CAST(bunho as signed)) FROM temp_tbl;<참고>
https://www.w3schools.com/sql/func_mysql_cast.asp
MySQL CAST() Function
MySQL CAST() Function ❮ MySQL Functions Example Convert a value to a DATE datatype: SELECT CAST("2017-08-29" AS DATE); Try it Yourself » Definition and Usage The CAST() function converts a value (of any type) into the specified datatype. Tip: See also t
www.w3schools.com