Sql course dec1

Course Outline

SQL Programming

SQL Cheat Sheet

create table dept (deptno int(2), dname varchar(15), loc varchar(12));

insert into dept values (10, 'accounting', 'new york'), (20, 'research', 'london'), (30, 'sales', 'paris'), (40, 'operations', 'berlin');

select * from dept;

---

create table salgrade (grade int(1), losal int(4), hisal int(4));

insert into salgrade values (1, 700, 1200), (2, 1201, 1400), (3, 1401, 2000), (4, 2001, 3000), (5, 3001, 9999);

select * from salgrade;