Skip to Main Content

SQL & PL/SQL

Need help on Round() function to skip last 2 values

User_X9S6MDec 17 2022

CREATE TABLE TEST(CURR)AS
(
SELECT 123.163612 FROM DUAL UNION ALL
SELECT 1237.1728788 FROM DUAL UNION ALL
SELECT 2828.2282811 FROM DUAL UNION ALL
SELECT 282.1886 FROM DUAL
)
Expected result:
Output:
123.1636
1237.17288
2828.22828
282.19

When I tried the round() got result below
SELECT ROUND(CURR,4) FROM test;
ROUND(CURR,4)
123.1636
1237.1729
2828.2283
282.1886

This post has been answered by Frank Kulash on Dec 17 2022
Jump to Answer
Comments
Post Details
Added on Dec 17 2022
12 comments
146 views