SQL – You have created an Employee table as follows…


You have created an Employee table as follows.

CREATE TABLE Employees (
   ID int NOT NULL,
   LastName varchar(255) NOT NULL,
   FirstName varchar(255),
   Age int,
   TerminationDate DATE,
   HireDate DATE,
   Primary Key(ID)
 );

In the given context, which of these is a correct way to define a constraint that says that the TerminationDate must be after the HireDate?

Related Posts

Close Bitnami banner
Bitnami