SELECT     * form
                          (SELECT     TOP (1) *
                            FROM          datab
                            ORDER BY Date_Recorded) AS datab1
UNION ALL
SELECT     * form
                          (SELECT     TOP (1) *
                            FROM          datab AS datab_1
                            ORDER BY Date_Recorded DESC) AS datab2

这个语句有问题哦，就想查一个表的某个时间段的第一条和最后一条，谁能帮帮我啊，郁闷死啦

[ 本帖最后由 ylof1986 于 2010-8-16 14:53 编辑 ]