I have a question about my sql query. I need to exclude all the rows that have the value 'f' in it.
I have tried doing
SELECT * FROM table WHERE type NOT IN ('f')
You apparently want to see rows where no other rows for the same name has the value
select t1.* from the_table t1 where not exists (select * from the_table t2 where t1.name = t2.name and t2.type = 'f');
If no such row exists the query will not return
null it will simply return no rows at all.