select statement

[tiger66]

Hi I have a database question
I am just wondering how can I extend my select statement below so that it only output selected record once for all the repeat record

select requestor,requestorfirstname, (decode(pcorderr, 1, 'PC')) as service
from pcOrder
where requestor='Joe'
and pcorderr =1

Thanks

[Ribeyed]

HI,
use "SELECT DISTINCT(fieldname) " in your sql statement.

[kanakaprasad]

try to avoid using distinct in select. cause if u have huge table then it takes time to fetch the data. so try to get the unique records posibly with select fields from *** way.

good luck