Filtering out duplicates

[degroat]

Is there a way to do a select statement and have it filter out duplicates of a specified field.... i.e. a DB with two fields, ID and TITLE and only want to return one ID with a specified title name.

 

[swampBoogie]

select min(id) as id,title
from t
group by title

 

[degroat]

I'm sorry, but I'm just not getting the 'as' thing there....

I'm wanting to select *. How would I do that?

 

[lebisol]

SELECT DISTINCT column_name(s)
FROM table_name

http://www.w3schools.com/sql/sql_select.asp

All the best!

> need more info?
:: don't click HERE ::