Left Outer Join question
- (ChrisR)
- (20)
- June 7, 2006, 10:26:29 PM EDT
One approach
- (ben_tilly)
- (6)
- June 8, 2006, 01:13:51 PM EDT
Some variation on MIN...
- (ChrisR)
- (3)
- June 8, 2006, 11:10:15 AM EDT
It probably will not optimize
- (ben_tilly)
- (2)
- June 8, 2006, 01:27:27 PM EDT
Yep, took forever to run.
- (ChrisR)
- (1)
- June 8, 2006, 02:00:51 PM EDT
Nothing non-standard about that
- (drewk)
- June 8, 2006, 02:40:14 PM EDT
Pre indentation
- (ChrisR)
- (1)
- June 8, 2006, 02:02:57 PM EDT
Bug, indentation can be lost during edits (new thread)
- (ben_tilly)
- June 8, 2006, 02:18:49 PM EDT
Does SQL Server support "DISTINCT ON"?
- (drewk)
- (12)
- June 8, 2006, 08:55:49 AM EDT
That is really what I need!
- (ChrisR)
- June 8, 2006, 10:56:50 AM EDT
The more readable version is invalid (at least in Oracle)
- (ben_tilly)
- (10)
- June 8, 2006, 01:12:25 PM EDT
Hmm, both Postgres and MySQL support the same non-standard?
- (drewk)
- (9)
- June 8, 2006, 01:49:01 PM EDT
Can you please help me find mine?
- (folkert)
- June 8, 2006, 02:04:49 PM EDT
That is a MySQL shortcut
- (ben_tilly)
- (7)
- June 8, 2006, 02:14:38 PM EDT
Not surprising
- (drewk)
- (2)
- June 8, 2006, 02:42:46 PM EDT
Or you didn't double-check enough
- (ben_tilly)
- (1)
- June 8, 2006, 02:50:14 PM EDT
Also possible
- (drewk)
- June 8, 2006, 04:17:32 PM EDT
I've encountered that problem.
- (static)
- (3)
- June 8, 2006, 08:48:27 PM EDT
Justifiable arrogance in many cases
- (ben_tilly)
- (2)
- June 8, 2006, 09:18:47 PM EDT
Oh I have little doubt about that.
- (static)
- (1)
- June 8, 2006, 09:35:59 PM EDT
Oracle is picky but...
- (ben_tilly)
- June 8, 2006, 10:03:53 PM EDT