怎么用一个语句查询一个表的两条数据啊~~~SOS宅急送
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 编辑 ]