Re: Discoverer Help needed
Date: Thu, 29 Mar 2001 17:07:23 +0100
Message-ID: <tc6ne9g0ok75fc_at_xo.supernews.co.uk>
Discoverer allows you to do all this without having to write queries and create views. That is the point of these Query tools, you don't have to know SQL. You can create calculated fields. In your case the calculated field will be count_distinct(field1) I think. (I am afraid I do not have Discoverer in front of me, but I think that is the function name).
I think Discoverer automatically groups on the remaining fields... It makes these assumptions for you.
Nick P
"Jim Wolfe" <jim_wolfe_at_sra.com> wrote in message
news:smHw6.11767$Uw.662585_at_newsread1.prod.itd.earthlink.net...
> I'm fairly new to Discoverer and am trying to implement a SQL query using
> this tool. Is there a way for discoverer to implement a query of the
> following form?
>
> select count(distinct field1), field2
> from table
> group by field2
>
> I know I could create a view implementing this query then use Discoverer
> query the view, but that pretty much defeats the purpose of the tool.
> Thanks
> Jim Wolfe
> jim_wolfe_at_sra.com
>
>
Received on Thu Mar 29 2001 - 18:07:23 CEST