Question

Write an SQL Query to insert the following data into the EMPLOYEES table: 101, Ravi Kumar, 2015-06-01, 1.70.

Answer 1

INSERT INTO EMPLOYEES (EmployeeID, EmpName, HireDate, Salary_in_Lacs)
VALUES (101, 'Ravi Kumar', '2015-06-01', 1.70);