SQL Server
queries.sql
SQL Server
queries.sql
-- create CREATE TABLE EMPLOYEE ( empId int, name varchar(15), dept varchar(10) ); -- insert INSERT INTO EMPLOYEE(empId,name,dept) VALUES (1, 'Clark', 'Sales'); INSERT INTO EMPLOYEE(empId,name,dept) VALUES (2, 'Dave', 'Accounting'); INSERT INTO EMPLOYEE(empId,name,dept) VALUES (3, 'Ava', 'Sales'); -- fetch SELECT * FROM EMPLOYEE; GO
STDIN
STDIN
Output:
Click on RUN button to see the output