``` SELECT from system info WHERE NOT EXISTS SELECT FROM pro

Question

``` SELECT from system info WHERE NOT EXISTS SELECT FROM processes WHERE name LIKE auditd ```

Prakhar · Answer

Thanks But I guess it should be processes table instead of system info

fritz · Answer

`system info` is used to return a single row of data for any device which does not have the desired process running You could just as easily write ``` SELECT 1 WHERE NOT EXISTS SELECT FROM processes WHERE name LIKE auditd ``` If you instead wrote `select from processes` it would just return a giant list of the running processes for every device not running auditd which doesn t sound like the goal you stated initially

Prakhar · Answer

Ohh thanks didn t know that