I came across hj with the following situations.
Distinct - Group by
What are their difference, for the two Bring me the same result ???
If possible, mention another query ...
Code1
SELECT DISTINCT deptno
FROM emp;
]
SELECT deptno
FROM emp group by deptno;
Valeu galera ..