Sql高手請進
有一個表factgood 字段如下(factno 廠商編號
good 貨品編號
dtslipdate 報價日期
fprice 價格)請用一條sql語句求出某一廠商的所有貨品的最近一次報價
例如record1 : '001','001stk1','031215','20'
record2 : '001','001stk2','031215','20'
record3 : '001','001stk3','031215','20'
record4 : '001','001stk1','031216','20'
record5 : '001','001stk3','031217','20'
record6 : '001','001stk2','031218','20'
record7 : '001','001stk1','031219','20'
record8 : '001','001stk2','031220','20'
應得的結果是
'001','001stk3','031217','20'
'001','001stk1','031219','20'
'001','001stk2','031220','20'