Re: [Firebird-devel] Using DISTINCT and ORDER

[Milan B. <mi...@pa...>]

Ain Valtin wrote:
> SELECT DISTINCT PK FROM Customers WHERE(..) ORDER BY Name
> and later when I need details I use the PK to load full record.

If it is really a PK, you don't need to use DISTINCT at all. All PKs are 
distinct by definition.

-- 
Milan Babuskov
http://njam.sourceforge.net
http://www.flamerobin.org