SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE emp ( EMPNO INT PRIMARY KEY, ENAME VARCHAR(50), JOB VARCHAR(50), MGR INT, HIREDATE DATE, SAL DECIMAL(10, 2), COMM DECIMAL(10, 2), DEPTNO INT ); INSERT INTO emp (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) VALUES (7369, 'Raj', 'CLERK', 7902, '2005-12-17', 800, NULL, 20), (7499, 'Amit', 'SALESMAN', 7698, '2006-02-20', 1600, 300, 30), (7521, 'Suresh', 'SALESMAN', 7698, '2006-02-22', 1250, 500, 30), (7566, 'Ravi', 'MANAGER', 7839, '2006-04-02', 2975, NULL, 20), (7654, 'Vikram', 'SALESMAN', 7698, '2006-09-28', 1250, 1400, 30), (7698, 'Anil', 'MANAGER', 7839, '2006-05-01', 2850, NULL, 30), (7782, 'Manoj', 'MANAGER', 7839, '2006-06-09', 2450, NULL, 10), (7788, 'Arjun', 'ANALYST', 7566, '2007-12-09', 3000, NULL, 20), (7839, 'Vivek', 'PRESIDENT', NULL, '2006-11-17', 5000, NULL, 10), (7844, 'Sunil', 'SALESMAN', 7698, '2006-09-08', 1500, 0, 30), (7876, 'Prakash', 'CLERK', 7788, '2008-01-12', 1100, NULL, 20), (7900, 'Dinesh', 'CLERK', 7698, '2006-12-03', 950, NULL, 30), (7902, 'Naveen', 'ANALYST', 7566, '2006-12-03', 3000, NULL, 20), (7934, 'Rohan', 'CLERK', 7782, '2007-01-23', 1300, NULL, 10); CREATE TABLE dept ( DEPTNO INT PRIMARY KEY, DNAME VARCHAR(50), LOC VARCHAR(50) ); INSERT INTO dept (DEPTNO, DNAME, LOC) VALUES (10, 'ACCOUNTING', 'Mumbai'), (20, 'RESEARCH', 'Bangalore'), (30, 'SALES', 'Delhi'), (40, 'OPERATIONS', 'Chennai'); CREATE TABLE dupes ( id INTEGER, name VARCHAR(10) ); INSERT INTO dupes VALUES (1, 'NAPOLEON'); INSERT INTO dupes VALUES (2, 'DYNAMITE'); INSERT INTO dupes VALUES (3, 'DYNAMITE'); INSERT INTO dupes VALUES (4, 'SHE SELLS'); INSERT INTO dupes VALUES (5, 'SEA SHELLS'); INSERT INTO dupes VALUES (6, 'SEA SHELLS'); INSERT INTO dupes VALUES (7, 'SEA SHELLS'); create view V as select e.ename ||' '|| cast(e.empno as char(4))||' '|| d.dname as data from emp e, dept d where e.deptno=d.deptno Select data from V;