类型:转载 责任编辑:asp.net 日期:2007/05/23
热门软件下载:
有两张表:
1. master: (maKey,CheckDate,Content)
样本数据:
1 2001-02-04 good
2 2001-02-05 better
3 2002-03-08 worst
...
2. detail: (deKey,maKey,ReceiveTime)
1 1 2001-01-01 01:11:22
2 1 2001-01-01 01:11:23
3 2 2002-01-01 01:11:23
4 2 2002-01-02 01:11:23
5 1 2001-01-01 01:11:23
按ReceiveTime降序,列出master内容(不要重复).
返回如下:
2 2001-02-05 better
1 2001-02-04 good
网友回答: