Home > Topic List > ORACLEDISTINCT
Collection
Like
Oracle's distinct usage can filter duplicate rows in the result set to ensure that the value of the specified column or columns returned in the "SELECT" clause is unique. The syntax is "SELECT DISTINCT column 1, column 2, column 3... from table name". "distinct" will sort the returned result set and can be used in conjunction with "order by" to improve efficiency.
7395 times of learning
Collection
5147 times of learning
Collection
11949 times of learning
Collection
11913 times of learning
Collection
