SQLite Online Compiler
Run Script
Main.sql
Input
/* Create a table called Employee */ CREATE TABLE Employee(EmpID INT, Name VARCHAR(255), City VARCHAR(255)); /* Insert some records in the Employee table */ INSERT INTO Employee VALUES(1,'John', 'London'); INSERT INTO Employee VALUES(2,'Marry', 'New York'); INSERT INTO Employee VALUES(3,'Jo', 'Paris'); INSERT INTO Employee VALUES(4,'Kim', 'Amsterdam'); INSERT INTO Employee VALUES(5,'Ramesh', 'New Delhi'); /* Display all records of Employee table */ SELECT * FROM Employee;
Output