Groups > comp.databases.oracle.misc > #1065

Re: Format A Calculated Column in a Query?

Newsgroups	comp.databases.oracle.misc
Date	2020-09-10 19:42 -0700
References	<JJk4j.40621$G23.965@newsreading01.news.tds.net> <1196547063.669257@bubbleator.drizzle.com> <51m4j.40622$G23.23443@newsreading01.news.tds.net> <8667d307-b13c-458c-b1a2-cfb04d7aab3b@s8g2000prg.googlegroups.com>
Message-ID	<3e45d90e-58de-4d84-b817-e353a5106e7en@googlegroups.com> (permalink)
Subject	Re: Format A Calculated Column in a Query?
From	Tuân Nguyễn Bá <tuanng.101099@gmail.com>

Show all headers | View raw

SELECT mem.firstname, mem.lastname, pos.position, cam.campusname, (ROUND(pos.yearlymembershipfee / 12, 2)) AS Monthly_Dues
FROM MEMBERS MEM, POSITION POS, CAMPUS CAM
WHERE MEM.POSITIONID = POS.POSITIONID AND MEM.CAMPUSID = CAM.CAMPUSID
ORDER BY cam.CampusName DESC, mem.LastName ASC;

I tried with ROUND() and it worked :))

Back to comp.databases.oracle.misc | Previous | Next | Find similar

Thread

Re: Format A Calculated Column in a Query? Tuân Nguyễn Bá <tuanng.101099@gmail.com> - 2020-09-10 19:42 -0700

csiph-web