whoops forget the group by clause
select max(serial) from table
where clause
group by customer_id
order by...
bastien
From: ziv gabel <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] begginer question
Date: Sat, 03 Sep 2005 21:34:31 +0200
Hi everyone
I just need som
select max(serial_Num) from table where...
bastien
From: ziv gabel <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] begginer question
Date: Sat, 03 Sep 2005 21:34:31 +0200
Hi everyone
I just need something that I believe is very simple only I can't find an
an
Select * from tablename group by customername order by serialnum DESC;
or
select distinct * from tablename order by serialnum DESC;
On Saturday 03 September 2005 12:34 pm, ziv gabel wrote:
> Hi everyone
> I just need something that I believe is very simple only I can't find an
> answer for it
gabel [mailto:[EMAIL PROTECTED]
Sent: Sabado, 03 de Septiembre de 2005 02:35 p.m.
To: php-db@lists.php.net
Subject: [PHP-DB] begginer question
Hi everyone
I just need something that I believe is very simple only I can't find an
answer for it anywhere
I have a database that each row has a ma
Hi everyone
I just need something that I believe is very simple only I can't find an
answer for it anywhere
I have a database that each row has a machine, its serial, the customer and
other details. The problem is that I have customers with more than one
machine and I need to query for all the row
