select rank() over

select * from (select rank() over(partition by barcode order by sheetdate) num,

* from ScanRecord where scanMode=0 and workStageName='QC')t where num=1

posted @ 2013-11-09 10:52 enif 阅读(308) 评论(0) 编辑收藏举报