Scribd
Upload
4 views1 page

SQL Employee Management Practices

The document contains SQL commands for creating and managing an 'Employees' table, including creating the table, inserting records, selecting all records, and updating specific fields. It demonstrates inserting multiple employees with their details and modifying employee information such as last names and IDs. The document also includes a correction of the hire date for a specific employee.

Uploaded by

Megha Baitha
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views1 page

SQL Employee Management Practices

The document contains SQL commands for creating and managing an 'Employees' table, including creating the table, inserting records, selecting all records, and updating specific fields. It demonstrates inserting multiple employees with their details and modifying employee information such as last names and IDs. The document also includes a correction of the hire date for a specific employee.

Uploaded by

Megha Baitha
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SQL PRACTISE:

CREATE TABLE Employees(EmployeeID INT,FirstName Varchar(32) , LastName


Varchar (32), Department Varchar (32), Salary int, HireDate date);
INSERT INTO Employees VALUES(1,'John','doe','IT',60000,2018-05-20);
SELECT * from Employees;
INSERT INTO Employees VALUES(1,'Jane','Smith','HR',55000,'2019-07-15');
INSERT INTO Employees VALUES(1,'Alice','Brown','IT',70000,'2017-03-12');
UPDATE Employees SET lastname='Doe' where firstname='John';
UPDATE Employees SET employeeid=3 where firstname='Alice';
UPDATE Employees SET employeeid=2 where firstname='Jane';
update Employees set hiredate='2018-05-20' where employeeid=1;

You might also like