Re: [GENERAL] COUNT() with ORDER BY

On Mon, Jan 14, 2008 at 09:02:46PM +0200, Andrus wrote: > create temp table test (col char); > select count(col) from test order by col; > > causes > > ERROR: column "test.col" must appear in the GROUP BY clause or be used in > an aggregate function > SQL state: 42803 > > > How to fix this ?

[GENERAL] COUNT() with ORDER BY

create temp table test (col char); select count(col) from test order by col; causes ERROR: column "test.col" must appear in the GROUP BY clause or be used in an aggregate function SQL state: 42803 How to fix this ? This statement is generated by DbLinq driver and it is difficult to re-qrite

Re: [GENERAL] COUNT() with ORDER BY

fervent with love. Princes abandoned their pomp; maidens suffered martyrdom. Whence came this influence? The Messiah was come. These were the effect and sign of His coming. 773. Destruction of the Jews and heathen by Jesus Christ: Omnes gentes venient et adorabunt eum.156 Parum est ut,157 etc. Pos

Re: [GENERAL] COUNT() with ORDER BY

On 14 jan, 17:02, "Andrus" <[EMAIL PROTECTED]> wrote: > create temp table test (col char); > select count(col) from test order by col; > > causes > > ERROR: column "test.col" must appear in the GROUP BY clause or be used in > an aggregate function > SQL state: 42803 > > How to fix this ? > This st