Database views is not showing records but showing the count

[Hareesha]

Database views is not showing records but showing the count.

Below are the where clause i have used.

[Hareesha]

Hi,

if i delete a where clause of sys_user_group,i am getting the table but for the same parent ,skills are repeating as shown below.I need to exclude duplicate one's 

[Hareesha]

[Ankur Bawiskar]

you are still using incorrect where clause

I think you missed my earlier comment

update where clause for sys_user_group as this

usergrp_parent=grpmem_group

Regards
Ankur

[Hareesha]

I have used above clause for that only its showing no records found.SO i have made it inactive

[Ankur Bawiskar]

but your latest screenshot still shows the incorrect where clause