Re: The keyword 'distinct' question

Posted in 1998

andy@pneu.com — Thu, 09 Apr 1998 11:46:48 -0600 — source: Informix-list mailing list archive (1991-1998)

In article <MPG.f943f4aafd7711d989682@news.callamer.com>, kyle@alh.com (Kyle Campbell) wrote: > > According to the BNF Grammar in the Informix Guide to SQL Syntax the > following statement should be legal: > > Select distinct ( sum (distinct <col1> ) ) from <table>> > It doesn't like the fact that I'm using nested 'distinct' key word. We > need this or we'll have to rework our logic for other queries. > > Thanks, > Kyle Campbell > kyle@alh.com > You can use "unique" in your query. Bye. Andy Bettin -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading