Loading

how to display only decimal number in sql +

MAHAMDSALAM MULLA

4y979SQL

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
What do you mean by only decimal, numbers after decimal? like 2.112 => 112 then use this
SELECT (yourNum % 1)
Muhammad Imran Ansari4y ago
Use the following query:
DECLARE @num DECIMAL(4,3) = 2.938
SELECT PARSENAME(@num, 1)
Firoz Ansari4y ago
Using Sql Server

SELECT FORMAT(4.3563746,'N2')

and using MySql

SELECT ROUND(325.3547, 2);