ation by using an alias for the
expression:
mysql> SELECT id,FLOOR(value/100) AS val FROM tbl_name
GROUP BY id,val ORDER BY val;
C:
-Original Message-
From: Brian Warn [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 4:31 PM
To: MySQL List
Subject: select count
I'm stuck right now with using v. 3.22.32. Yes, I know I need to
upgrade, but I can't for various reasons. Anyway, I need to do a select
count(distinct column) from table query, but can't since this version
doesn't support it. How can I do
It should work fine as printed...but you'll need mysql 3.23.xx
On Fri, 6
Apr 2001, Temeschinko, Michael wrote:
>
> hi,
>
> I need to make a select like above in the subject count distinct (I need the
> count of the different values of a coloumn)
>
> Hope you guys won't let me die silly!
> :-)
hi,
I need to make a select like above in the subject count distinct (I need the
count of the different values of a coloumn)
Hope you guys won't let me die silly!
:-)
greetings from germany
Micha
--
A train station is a station where a train stops
But what the hell is a workstation?
