Ok, thanks for the insight.

I will try that.

Yes you are right. If I remove ID, and name from select and group by it works fine.

But I have to list Employee ID, name along with % percentage compliance...

If you look at the code, I have already added the fields on select and group by statements. But now I'm not getting the %compliance I needed.

For example, it's showing...

Thanks for pointing this out and that fixed the error.

Now the problem is that I need add more coulmns for example employee name, dept, flu date etc along with %...

I found a problem with the below query, if someone has a record for FLDPHYSICAL '110','TBSS' and '109' it creates 3 seprate rows instead of a single row. How can...

n/a

I tried to incorporate what you suggest and I'm getting more records.

Now I'm getting lots of duplicate records from FITTEST table, I need only the last date (...

Thanks for the case statment, it worked fine.

But I have another problem, what i was looking for was to list all records on employee table even if there is...