Re: Count

From: <nasof_at_hotmail.com>
Date: Tue, 18 Aug 1998 15:05:09 GMT
Message-ID: <6rc575$8rb$1@nnrp1.dejanews.com>

Just use:

select count(*)
from table
where blah=blah and etc....

In article <6rb9hq$dd5$1_at_news1.tele.dk>, "Ivan Bajon" <ib_at_ed.dk> wrote:
> I'm having problems formulating a select statement with the count function.
> I have a query where a lot of columns are selected - some of which are
> concatenated. I can't write:
>
> select count(distinct field1, field2, field3||field4, field5, etc.)
> from some_tables
> where something=something
>
> I tried taking the original select statement and putting a count around it
> but I can't seem to make it work. All I want to know is how many rows will
> be selected. I bet there's a beatiful way of formulating this. Would anyone
> care to comment please?
>
> - Ivan Bajon
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Aug 18 1998 - 10:05:09 CDT