Re: [sqlite] nested functions in select

[D. Richard Hipp]

On Thu, 2005-05-12 at 21:50 -0400, Doug Henry wrote:
> I was trying to do something like: select count(distinct(something)) from 
> table;

   SELECT count(*) FROM (SELECT DISTINCT something FROM table);


-- 
D. Richard Hipp <[EMAIL PROTECTED]>