Please help me with this confusion .
What is the difference between the following queries
Select UNIQUE(c1),c2,c3 from t1;
Select DISTINCT c1,c2,c3 from t1;
Select c1,DISTINCT c2,c3 from t1;
Does the above queries return :
1. Unique values for c1 and the corresponding min(ROWNUM) values for c2,c3.
2. Distinct combination of values for c1,c2,c3.
3. Distinct combination of values for c2,c3 and the correponding min(ROWNUM)
values for c1.
Please reply