database - SQL Redundant Results -

hey stuck 1 query , new sql , oracle. have database lastname, firstname, email, , state. have database skills each of people first database have , each skill has id number. need produce list of specific people specific skill id ('3') when that, redundant information, in, same name comes 3 or 4 times each , don't want that.

this query used:

select firstname, lastname, email consultants, skills skills.expertiseid = '3' , consultants.state = 'nj'  or consultants.state = 'ny'; 

any appreciated

select firstname, lastname, email consultants, skills skills.expertiseid = '3' ,  ( consultants.state = 'nj' or consultants.state = 'ny' ); group firstname, lastname, email 

use group eliminate repetitive rows