摘要： --查询第八条至第十六条数据--分页 ROW_NUMBER() OVER(ORDER BY orderID DESC) AS 字段编号select title ,UnitPrice from(select title,UnitPrice, ROW_NUMBER() over(order by UnitPrice) as rowNumber from books) tempwhere temp.rowNumber between 1 and 10--页大小 7 第二页: 猪那个问题就是这个问题呗 少了个OrderByselect top 10 title,UnitPrice from books 阅读全文

摘要： ggceshiyixia 阅读全文

摘要： ZOJ Problem Set - 2100SeedingTime Limit:1 Second Memory Limit:32768 KBIt is spring time and farmers have to plant seeds in the field. Tom has a nice field, which is a rectangle with n * m squares. There are big stones in some of the squares.Tom has a seeding-machine. At the beginning, the machine li 阅读全文