SELECT     TOP 2 ejoindate

FROM         etest

GROUP BY ejoindate

ORDER BY ejoindate DESC

(Above query will display the two dates as two rows)

SELECT     MAX(ejoindate) AS m1,

                          (SELECT     MAX(ejoindate)

                            FROM          etest

                            WHERE      ejoindate <

                                                       (SELECT    ...