SQL
unknown
plain_text
9 days ago
683 B
3
Indexable
CREATE TABLE EmployeeDetailsTable ( EmployeeID INTEGER PRIMARY KEY AUTOINCREMENT, FirstName TEXT, LastName TEXT, Salary DOUBLE, JoiningDate Timestamp, department TEXT, Gender TEXT) INSERT INTO EmployeeDetailsTable (FirstName, LastName, Salary, JoiningDate, department, Gender) VALUES ('Vikas', 'Ahlawat', 600000, '2013-02-15 11:16:28', 'IT', 'Male'), ('Nikitha', 'Jain', 530000, '2014-01-09 17:31:07', 'HR', 'Female'), ('Ashish', 'Kumar', 1000000, '2014-01-09 10:05:07', 'IT', 'Male'), ('Nikhil', 'Sharma', 480000, '2014-01-09 09:00:07', 'HR', 'Male'), ('Anish', 'Kadian', 500000, '2014-01-09 09:31:07', 'Payroll', 'Male'); SELECT * FROM EmployeeDetailsTable
Editor is loading...
Leave a Comment