There is no need to use parenthesis.
This will produce the results you expect:
<pre>select distinct no, name from pen</pre>
The DISTINCT keywork eliminates duplicate <b>rows </b>from the results of the query. It applies to all of the columns included in the select list.
You can use parenthesis with one column, but when including more than one, the ORA-00907 error is generated.
Discuss This Question: 4  Replies