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 |