SELECT * FROM employee;
| emp_id | emp_name | department | emp_salary |
|---|
INSERT INTO student values(1,"Aman",D1,34000);
INSERT INTO student values(2,"Ram",D2,43000);
INSERT INTO student values(3,"Ramesh",D1,2000);
INSERT INTO student values(4,"John",D3,65000);
INSERT INTO student values(5,"Sita",D1,10000);
INSERT INTO student values(6,"Dinesh",D2,15000);
SELECT * FROM employee;
| emp_id | emp_name | department | emp_salary |
|---|---|---|---|
| 1 | Aman | D1 | 34000 |
| 2 | Ram | D2 | 43000 |
| 3 | Ramesh | D1 | 20000 |
| 4 | John | D3 | 65000 |
| 5 | Sita | D1 | 10000 |
| 6 | Dinesh | D2 | 15000 |