- 博客(2)
- 资源 (3)
- 收藏
- 关注
原创 取类别区分的TOP10 by Access(学习备注)
感谢论坛ACCESS版两位版主的指导。帖子链接:http://bbs.csdn.net/topics/390316494做一下学习记录:select InvNo,Model,Amount from dbo_InvoiceDetail awhere 10>(select count(*) from dbo_invoiceDetail b where b.invNo=a.in
2012-12-18 14:14:05 3326 1
原创 取类别区分的TOP10(学习备注)
SELECT [InvNo],[Model],[Amount] FROM (SELECT [InvNo],[Model],[Amount],ROW_NUMBER() OVER(partition by [InvNo] ORDER BY [Amount] DESC) AS [Row Number] FROM [InvoiceDetail]) AWHERE [Row Number]
2012-12-14 11:16:56 2925 1
超酷VBA工程加锁解锁器 By ldhyob
2011-03-15
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人