Count(*) in Delete statement How can I use count(*)>0 in a where clause of a delete statement?

My scenario is  if count(*)&gt;0 then delete the table1.  I've tried this code:

delete table1 where c='n' and having count(*)&gt;0;


But it's getting an error.
Your query wants to delete all the rows in table1 where the value of c is n.

Simply modify the DELETE statement so it no longer mentions the COUNT(*) &gt; 0, since that doesn't change the semantics of the query at all.

DELETE
FROM table1
WHERE c = 'n';