Listing 5 The two types of insert queries
INSERT INTO Employee (emp_id, emp_name, emp_ssno,emp_address, dept_id) select 4422, 'Mairsey Doats', '123456789','22 Dozy Doats Lane Kathmandu', 14 or INSERT INTO Employee (emp_id, emp_name, emp_ssno,emp_address, dept_id) values( 4422, 'Mairsey Doats', '123456789','22 Dozy Doats Lane Kathmandu', 14) INSERT INTO DeptTotals (year, week, dept_id,revenue) SELECT dd.year, dd.week, dd.dept_id, SUM(dd.revenue) FROM DeptDaily dd WHERE dd.year = 2002 and dd.week = 47 group by dd.year, dd.week, dd.dept_id