Re: Type for COUNT() as VAR ?

Got it ;-)

SELECT Module_ModuleType as LicProgPartID,'Module' as LicFor,CAST(COUNT(Module_ID) as NUMBER(10,0)) as NrInstances,Lic_RegCode FROM Licenses,Modules
WHERE Lic_ID=Module_LicenseID
AND MODULE_ID <> -1
GROUP BY Module_ModuleType,Lic_RegCode

"Jan Doggen" <j.doggen_at_BLOCKqsa.nl> wrote in message news:4386d249$0$11080$e4fe514c_at_news.xs4all.nl...
> Hello,
>
> 1) What type will NrInstances have in this query:
>
> 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 - 10:36:51 CET