摘要:
USE [AisLock20120221]GO/****** Object: StoredProcedure [dbo].[AAAAA_DDMangement] Script Date: 05/07/2012 08:31:31 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author: <Author,,Name>-- ALTER date: <2012/01/12,,>-- Description: < 阅读全文
摘要:
SELECT Finterid, Fbillno, Fdate, rownum FROM (select Finterid,Fbillno,Fdate, row_number() over(partition by Fbillno order by Fdate desc) as rowNum from icstockbill) k where k.rowNum=1 阅读全文