Posted by mcolson on 06/25/07 17:29

On Jun 25, 11:01 am, Roy Harvey <roy_har...@snet.net> wrote:
> What exactly is the datatype of Shift_Date? What action are you
> trying to take based on the comparison?
>
> If you want to compare them inside a SELECT this might get you
> started.
>
> SELECT A.ShiftDate as LastShiftDate,
> B.ShiftDate as NextToLastShiftDate
> FROM (SELECT * FROM TheTable
> WHERE Row_Index =
> (SELECT MAX(Row_Index) FROM TheTable) as A
> CROSS JOIN
> (SELECT * FROM TheTable
> WHERE Row_Index =
> (SELECT MAX(Row_Index)-1 FROM TheTable) as B
>
> Roy Harvey
> Beacon Falls, CT
>
> On Mon, 25 Jun 2007 15:44:07 -0000, mcolson <mcolson1...@gmail.com>
> wrote:
>
> >I am trying to compare the last two values in the same column of a
> >table. First of all, I have a column titled Row_Index that uses an
> >index which starts at 1 and increments by 1. What I am trying to do
> >is compare the values in the column 'Shift_Date' for the maximum value
> >of Row_Index and the (maximum value - 1) of Row_Index. I've been
> >trying to declare two strings, setting each string equal to one of my
> >values, and then comparing the strings. But this doesn't seam to be
> >working right. I'm not sure I am even declaring the strings
> >correctly. Does anyone know how I can do this. A sample of what one
> >of my values looks like in Shift_Date is ' 6/25/2007'.

When using the 'Last' function, do you have to have the columns sorted
by when they were entered?

[Back to original message]