The "1" has nothing to do with the DISTINTROW clause, it's a constant 
expresion for a column called NOW.  every row will start with  column "NOW" 
with the value 1 in it.

-g


-----Original Message-----
From:	John Pirkey [SMTP:mailjohnny101@y...]
Sent:	Wednesday, January 31, 2001 12:48 PM
To:	sql language
Subject:	[sql_language] Re: SELECT DISTINCT ROW 1

what database is thig used in? SQL Server, Oracle, Access, FoxPro, DB2???

i've never seen it either, but i've only dealt with SQL Server.

--- Brad Carroll <bradc@c...> wrote:
> Hi,
>
> If anyone can help me with this I'd be very grateful.  Recently I have
> inherited a number of terrible undocumented and very complex databases to
> maintain.  These databases not only have no documentation whatsoever in
> any form, but they are also FULL of bugs and problems.  Fixing these
> problems has not been easy, I can tell you!
>
> Anyway, I have come accross this SQL command I've never seen used before
> and hope someone can tell me what it means.
>
> It goes:
>
> SELECT DISTINCTROW 1 AS NOW, [Employee Details].[Hours], [etc].[etc]
>
> and so on.  So what does the "1" mean?  This is probably very basic stuff
> that every SQL programmer should know, but OK, I admit I don't know!  So
> if someone can help me that would be great.
>

John Pirkey
MCSD
John@S...
http://www.stlvbug.org