how to retrieve all employees

[Anonymous]

EmployeeID	PassportNo
1	45783
2	78142
4	39874
5	56874
6	12457
8	74871
9	5471

I have totally 10 Employees. here i have entered only who are all having passport those employee id only entered. and i want entered employee id status = 'yes' and not entered  employee id status = 'no' how to write expression ??????

[dsharmaqv]

do you want to enter manually or you have satus information stored in some other table

[Anonymous]

Hi,

Try this: count(Distinct {<Status = {'yes'}>} EmployeeID)