VFP 愛用者社區

[dreamer]

使用 vfp 如何取得群組之第一筆資料及最後一筆資料？

[dreamer]

Tigerlee:
謝謝您的解答，但還是霧煞煞(初學者)
zip name addr--->欄位名稱
100 name1 addr1
100 name2 addr2
100 name3 addr3
101 name4 addr4
101 name5 addr5
101 name6 addr6
101 name7 addr7
106 name8 addr8
106 name9 addr9
106 name10 addr10
106 name11 addr11
取得群組之第一筆資料及最後一筆資料，結果如下：
zip name第一筆 name最後一筆 addr第一筆 addr最後一筆
100 name1 name3 addr1 addr3
101 name4 name7 addr4 addr7
106 name8 name11 addr8 addr11

[garfield]

不然你用select top 1 yourdbf.* from yourdbf where zip='101' order by name desc into cursor mytempfile
這個是取(where) zip='101' 的NAME最後(desc)一筆(top 1)資料, 它是一個暫時性(into cursor)的檔案, 可用完就關閉它, 不會留下暫存檔的.
SELECT 詳細的用法請參考MSDN.

[yctsai]

select zip,name,addr from table group by zip into cursor tp1 &&最後一筆
select * from table order by zip desc into cursor tp2
select zip,name,addr from table group by zip into cursor tp3 &&第一筆
select a.*b.name,b.addr from tp1 a left join tp3 b on a.zip=b.zip into cursor tmp

tmp is the answer

[yctsai]

select zip,name,addr from table group by zip into cursor tp1 &&最後一筆
select * from table order by zip desc into cursor tp2
select zip,name,addr from tp2 group by zip into cursor tp3 &&第一筆
select a.*b.name,b.addr from tp1 a left join tp3 b on a.zip=b.zip into cursor tmp

tmp is the answer