Create Table EXAMS ( SUB_NO integer Not Null, STUDENT_NO integer Not Null, MARK decimal (3), DATE_TAKEN date Not Null, Primary Key (SUB_NO, STUDENT_NO, DATE_TAKEN) ); The above SQL statement is used to create the EXAMS table. Considering the EXAMS table;
Create Table EXAMS ( SUB_NO integer Not Null, STUDENT_NO integer Not Null, MARK decimal (3), DATE_TAKEN date Not Null, Primary Key (SUB_NO, STUDENT_NO, DATE_TAKEN) ); The above SQL statement is used to create the EXAMS table. Considering the EXAMS table;
Register to vote on and add code examples. Join our developer community to improve your dev skills and code like a boss!
No Good?
Help us improve our code examples by registering to vote on and add answers. Join our developer community to improve your dev skills and code like a boss!