How?

Yep, I can create like below...

CREATE TABLE Emp(

EmpID INT PRIMARY KEY,

Emp_Name VARCHAR(100),

Emp_JoinDate DATE,

Emp_Salary Money,

Emp_Designation Varchar(50),

Emp_ManagerID INT FOREIGN KEY REFERENCES Employee(EmpID)

)

You may get issues while inserting into Emp_ManagerID , you may use null value for that.