Nothing non-standard about that

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #258,187

6/8/06 2:40:14 PM

In fact, that's the solution I'd like to think I'd have come up with if I'd worked on it long enough.

===

Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]

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