How can I prevent multiple outputs from a query?

[dominod]

Hi there 

 

Im just wondering how I can prevent the query from outputing the same name twice in a query?

 

Example:

 

If I query and it outputs:

 

Name-        Age-        Location-

Roger          23          New York

Eric              29          Miami

Eric              48          Boston

 

Is there a way to make it recognize that it already outputed "Eric" then make it skip the next eric so it just outputs:

 

Name-        Age-        Location-

Roger          23          New York

Eric              29          Miami

 

?

 

Thanks alot guys

[Adam]

Use a group by:

 

(...) GROUP BY name

[dominod]

Thank you soooooo much!