DamianAlamous
New Member
I want to compare two tables using the minus command in sqldeveloper (oracle sql). One table (TABLE A) was generated with a procedure (procedure A) that produced values in column X with the following precision:80.3921568627TABLE B (procedure B) produced the following version of the same data:80.39215686For the purposes of my task, I do not care about precision beyond two decimal places. How do I modify the syntax of my query (see below) to ignore all beyond the first two decimal places:\[code\]select id,a_valfrom table_Aminus select id,b_valfrom table_B\[/code\]