Combining WHERE Conditions : Where « Select Query « Oracle PL / SQL






Combining WHERE Conditions

  
SQL> CREATE TABLE SAT (
  2     StudentID  INT NOT NULL,
  3     ExamID     INT NOT NULL,
  4     Mark       INT,
  5     IfPassed   SMALLINT,
  6     Comments   VARCHAR(255),
  7     CONSTRAINT PK_SAT PRIMARY KEY (StudentID, ExamID)
  8  );

Table created.

SQL>
SQL>
SQL> INSERT INTO SAT (StudentID,ExamID,Mark,IfPassed,Comments) VALUES (1,1,55,1,'Satisfactory');

1 row created.

SQL> INSERT INTO SAT (StudentID,ExamID,Mark,IfPassed,Comments) VALUES (1,2,73,1,'Good result');

1 row created.

SQL> INSERT INTO SAT (StudentID,ExamID,Mark,IfPassed,Comments) VALUES (2,3,44,1,'Hard');

1 row created.

SQL> INSERT INTO SAT (StudentID,ExamID,Mark,IfPassed) VALUES (2,6,63,1);

1 row created.

SQL>
SQL>
SQL>
SQL> SELECT StudentID, Mark, Comments FROM SAT
  2  WHERE ExamID = 1 AND IfPassed = 1;

 STUDENTID       MARK
---------- ----------
COMMENTS
--------------------------------------------------------------------------------
         1         55
Satisfactory


1 row selected.

SQL>
SQL>
SQL> drop table SAT;

Table dropped.

   
    
  








Related examples in the same category

1.Query a varchar2 type column in where statement
2.The TO_DATE function in where clause
3.WHERE clause with a GROUP BY clause
4.A list of all Employees whose salary is more than $5000
5.Use an analytical function in a WHERE clause
6.Using the WHERE, GROUP BY, and HAVING Clauses Together
7.Use ROWNUM in where clause
8.Where clause converts text with date value format to date value
9.Use Trunc in where clause
10.List all employees who are younger than Jane
11.List all employees with salary between 1300 and 1600