Question

Write an SQL statement to create a table named EMPLOYEES, with the following specifications:

Column Name	Data Type	Key
EmployeeID	Numeric	Primary Key
EmpName	Varchar(25)
HireDate	Date
Salary_in_Lacs	Float(4,2)

Answer 1

CREATE TABLE EMPLOYEES (
 EmployeeID NUMERIC PRIMARY KEY
 EmpName VARCHAR(25,
 HireDate DATE,
 Salary_in_Lacs FLOAT(4,2)
);