HELP with code and results display
From: mj <mjohnson33_at_gmail.com>
Date: Fri, 15 Apr 2011 12:14:57 -0700 (PDT)
Message-ID: <c2b27034-28d7-4098-9a5b-d3ceb4b9c314_at_f11g2000vbx.googlegroups.com>
here's test code and results from same.
Date: Fri, 15 Apr 2011 12:14:57 -0700 (PDT)
Message-ID: <c2b27034-28d7-4098-9a5b-d3ceb4b9c314_at_f11g2000vbx.googlegroups.com>
here's test code and results from same.
SELECT distinct
(SELECT count(*) FROM TABLE1)*100/(SELECT count(*) FROM TABLE2)
percent
FROM TABLE1, TABLE2
Results = 46.571428571428571428571428571428571429
I'm trying to get a percentage as result, displayed as "46.57%" but can't figure out how to trip decimals and display the percent sign.
Any help would be much appreciated.
Thanks Received on Fri Apr 15 2011 - 14:14:57 CDT