悉野小楼

摘要： row_number 函数里面有个partition by可以先分组================SELECT*FROM(SELECTrid=ROW_NUMBER()OVER(PARTITIONBY分组ORDERBY排序DESC),*FROM表名)ASTWHERErid<=10==========SELECT * FROM(SELECT rid = ROW_NUMBER() OVER(PARTITION BY dept ORDER BY [time] DESC), * FROM TestTable) AS T WHERE rid <= 5 ===========with newt 阅读全文

摘要： int[, ,] array = new int[5, 2, 3]; //定义一个5 * 2 * 3 =30的三维数组(array.Length=30) 多维数组只算一个数组 array[1, 1, 1] = 3; array[1, 1, 2] = 4;。。。array[5, 2, 2] = 8;arrayy[5, 2, 3] = 9;===========数组的数组包括多维数组int[][][] array2 = new int[4][][];//数组的数组int[][] array = new int[][]{new int[]{1,2,4},new int[]{1,2,3... 阅读全文