Re: Alternative to MS Access Last() function
От | Scott Ford |
---|---|
Тема | Re: Alternative to MS Access Last() function |
Дата | |
Msg-id | CAA10533F41BB7448F7659D4D06719074A00BE@cx41.800onemail.com обсуждение исходный текст |
Ответ на | Alternative to MS Access Last() function ("Scott Ford" <Scott.Ford@bullfrogpower.com>) |
Ответы |
Re: Alternative to MS Access Last() function
Re: Alternative to MS Access Last() function |
Список | pgsql-novice |
Actually, I think I just figured it out. I'm not sure that I totally understand it - I've been passed the problem of converting it from someone else. But according to the documentation: ------------- The LAST function returns the value of the last record in the specified field. Syntax: SELECT LAST(column) AS [expression] FROM table Example: SELECT LAST(Age) AS highest_age FROM Persons ORDER BY Age -------------- So I think that I should just be able to use MAX(). Right? -----Original Message----- From: Michael Fuhr [mailto:mike@fuhr.org] Sent: March 1, 2006 1:21 PM To: Scott Ford Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] Alternative to MS Access Last() function On Wed, Mar 01, 2006 at 01:11:56PM -0500, Scott Ford wrote: > Does anyone know of a good alternative in postgres to the MS access last > function? What does it do? People who don't use Access might be able to answer if they knew what functionality you're after. -- Michael Fuhr
В списке pgsql-novice по дате отправления: