|
|
Posted by Roy Harvey on 06/25/07 16:01
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 <mcolson1590@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'.
Navigation:
[Reply to this message]
|