DISTINCT/SELECT statement?

[Crilon]

Hello all of you,
I am wondering what's the order when "DISTINCT" is used in SELECT statement? i.e. choosing "SELECT DISTINCT * from table_name", the
output is sorted with what order? How about if add distinct "ORDER BY"?
thanks for any input. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

To get output in a particular order, use ORDER BY. It will always take precedence. Without ORDER BY, data is not necessarily returned in any particular order, but DISTINCT is processed similar to GROUP BY, and GROUP BY necessarily has to order the data in order to group it, so it will have an effect on the order in the absence of ORDER BY. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --