By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
create table scores
(
name varchar2(15),
history_grade varchar2(1),
math_grade varchar2(1)
);
BEGIN
insert into scores (name, history_grade, math_grade) values ('Bill', 'A', 'A');
insert into scores (name, history_grade, math_grade) values ('Sue', 'F', 'F');
insert into scores (name, history_grade, math_grade) values ('Mary', 'C', 'B');
insert into scores (name, history_grade, math_grade) values ('Austin', 'C', 'A');
insert into scores (name, history_grade, math_grade) values ('Kyle', 'B', 'B');
END;
/
1 rows affected
SELECT *
FROM scores
WHERE (history_grade, math_grade) NOT IN (('A', 'A'), ('F', 'F'));
| NAME | HISTORY_GRADE | MATH_GRADE |
|---|---|---|
| Mary | C | B |
| Austin | C | A |
| Kyle | B | B |
SELECT *
FROM scores
WHERE NOT ( history_grade = 'A' AND math_grade = 'A' )
AND NOT ( history_grade = 'F' AND math_grade = 'F' );
| NAME | HISTORY_GRADE | MATH_GRADE |
|---|---|---|
| Mary | C | B |
| Austin | C | A |
| Kyle | B | B |
SELECT *
FROM scores
WHERE ( history_grade <> 'A' OR math_grade <> 'A' )
AND ( history_grade <> 'F' OR math_grade <> 'F' );
| NAME | HISTORY_GRADE | MATH_GRADE |
|---|---|---|
| Mary | C | B |
| Austin | C | A |
| Kyle | B | B |