SELECT * FROM employee;
emp_id | emp_name | department | emp_salary |
---|---|---|---|
1 | Aman | D1 | 34000 |
2 | Ram | D2 | 43000 |
5 | Sita | D5 | 10000 |
3 | Ramesh | D3 | 20000 |
4 | John | D4 | 65000 |
5 | Sita | D5 | 10000 |
SELECT DISTINCT * FROM employee;
emp_id | emp_name | department | emp_salary |
---|---|---|---|
1 | Aman | D1 | 34000 |
2 | Ram | D2 | 43000 |
5 | Sita | D5 | 10000 |
3 | Ramesh | D3 | 20000 |
4 | John | D4 | 65000 |