mysql query question

トップ ページ
添付ファイル:
Eメールのメッセージ
+ (text/plain)
このメッセージを削除
このメッセージに返信
著者: I.T. Damager
日付:  
To: PLUG
題目: mysql query question
I have a query something like this:

select * from stuff

I want to select rows where each name is distinct like:

select distinct name from stuff

The first query gives me all columns, but includes the duplicate names.
The second query gives me the name column with no duplicates. How can I
combine the two, so I get all columns, but without duplicate names?

Thanks

---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss