Pada Sat, 24 Aug 2002 00:29:40 -0600 (MDT)
[EMAIL PROTECTED] menulis :
> I want to SELECT rows excluding a duplicates on the "name" column.
> I tried to use DISTINCTROW, but it selects unique rows.
>
> Is it possible at all?
select field1,field2,distinct(field3),field4 from tablename;
or
select * from tablename group by fieldX;
--
Avoid unnecessary branches.
- The Elements of Programming Style (Kernighan & Plaugher)
MySQL 3.23.51 : up 66 days, Queries : 356.521 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone : +62 21 79199577 - HP : +62 8551044244 - Web : http://www.1rstwap.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
