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.
7316 times of learning
Collection
5109 times of learning
Collection
11858 times of learning
Collection
11841 times of learning
Collection
