[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
RE: [OT] SQL question
- To: <ukha_d@xxxxxxx>
- Subject: RE: [OT] SQL question
- From: "Mark Hetherington" <mark.egroups@xxxxxxx>
- Date: Fri, 22 Mar 2002 19:45:28 -0000
- Delivered-to: mailing list ukha_d@xxxxxxx
- Mailing-list: list ukha_d@xxxxxxx; contact
ukha_d-owner@xxxxxxx
- Reply-to: ukha_d@xxxxxxx
> Mark - what database is SELECT DISTINCT ON in ? SQL Server doesn't
like
> it, and SQL Server Books Online says the options are ALLDISTINCT
> ...... :(
Ah right. Sorry, didn't realise it was not standard, the docs did not
ientofy it as such. It is in PostgreSQL which I was using to test with (no
SQL server here).
Just checked the latest docs and they do now state it is not part of the
SQL
standard.
Shame really, saves messing about with joins for things like this.
Mark.
Home |
Main Index |
Thread Index
|