db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dyre.Tjeldv...@Sun.COM
Subject Re: distinct and order by
Date Thu, 31 Jan 2008 16:11:46 GMT
tom_ <tom12167@web.de> writes:

> I am using "disctinct" because of some self-joins and also needed to add an
> "order by" clause. An error is shown. Is it not possible to use distinct and
> order by together?

I think it is allowed. Executing

select distinct * from sys.systables order by tablename;

in ij works just fine. Could you show the error message you get, and
perhaps what the table looks like?


View raw message