2. then enter the code: select cast (id is int) from a.

3. Then enter the code: select cast (ID is decimal (18, x)) from a, where x represents decimal places. If you want to keep 2 decimal places, it is 2, and if you don't keep decimals, it is 0. This is complete.