select first(a) from ta order by a in access, is equivilent to
select a from ta order by a limit 1 Thanks Chad P.S. Note that access will always return the same value if you exclude the order by, this is not necessarily true with postgresql or any real RDBS. ----- Original Message ----- From: "peter" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 2:12 AM Subject: [SQL] grouping and first() > Hi, just wondering if anyone can tell me what replaces the first function > in access. > > > Thanks > > PEter > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
