SQL
Anonymous
plain_text
04/10/2025 6:14 AM
912 B
16
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 EmployeeDetailsTableEditor is loading...
Leave a Comment