Type for COUNT() as VAR ?
From: Jan Doggen <j.doggen_at_BLOCKqsa.nl>
Date: Fri, 25 Nov 2005 09:58:47 +0100
Message-ID: <4386d249$0$11080$e4fe514c_at_news.xs4all.nl>
Hello,
Date: Fri, 25 Nov 2005 09:58:47 +0100
Message-ID: <4386d249$0$11080$e4fe514c_at_news.xs4all.nl>
Hello,
SELECT Module_ModuleType as LicProgPartID,'Module' as LicFor,COUNT(Module_ID) as NrInstances,Lic_RegCode FROM etc.
2) Can I force it to be NUMBER(10,0) for instance?
Thanks
Jan
Received on Fri Nov 25 2005 - 09:58:47 CET