SQL

Question 1

Select all employee in Tbl Employees who are born between 06/10/1945 and 17/10/1948

Answer 1

SELECT * FROM employee

WHERE DOB BETWEEN ‘06/10/1945’ AND ‘17/10/1948’;

Question 2

Syntax for CREATE

Answer 2

CREATE TABLE

( []);

Question 3

Syntax for ALTER

Answer 3

ALTER TABLE

ADD ;