Posted by Kromey at 12:35pm Apr 22 '10DISTINCT is said to be non-deterministic. In actuality, what that means is that it's dependent upon database order (i.e. the order of data in the raw data files) and not any ordering you can control -- meaning you cannot control which row is chosen in a DISTINCT.
Public Boards
You can browse topics that 4K members have made public.
Debate & News
Media & Arts
Special Interest
Help & Advice
Lifestyle
Extreme
At least in MySQL
There are 11 private posts in this thread. You need to sign in to read them.
Below are the public posts you may view:
- DBAs to the rescue! Please! - Otter 4:40pm Apr 21 '10
- Yeesh, tough one - Kromey 5:41pm Apr 21 '10
- I ended-up going with your approach today - Otter 11:37am Apr 22 '10
- Any time - Kromey 12:38pm Apr 22 '10
- great idea! - Otter 10:27am Apr 22 '10
- I ended-up going with your approach today - Otter 11:37am Apr 22 '10
- Yeesh, tough one - Kromey 5:41pm Apr 21 '10
At least in MySQL - Kromey You currently have read-only access to this board. You must request an account to join the conversation.
Why Join 4thKingdom?
Note that there are no ads here. Just intelligent and friendly conversation. We keep
the spam out, the trolls out, the advertisers out… 4K is just a low-key, old-fashioned
site with members from around the world.
This community began in 1998, and we continue to accept new members today.