Hi All,
Please, I am trying to use CASE in a query statement as below:
***********************************
select emp_id,emp_name,
CASE
when ( emp_name like 'Scott') then 'First One'
else ' '
END as Description
from employes;
***********************************
What i need to do, is to print 'First One' with the first employe ONLY who is named 'Scott' even if there are others named 'Scott'
But the above example will print 'First One' for all employes who named 'Scott'
May be I am using the wrong function ..
Could you please assist?
Regards,
Mohammed