MSSQL-SQL SERVER一些使用中的技巧
摘要：
获取前一天时间"getdate() - 1"获取上一小时时间"dateadd(hour, -1, getdate())"order by field1, field2 可以更细致排序进行输出分页语句SELECT TOP $row * FROM (SELECT ROW_NUMBER() OVER (ORDER BY [Date] desc) AS RowNumber, * FROM [MyDb].[dbo].[Platform_Statistic]) A WHERE RowNumber > + ($page - 1) * $row ORDER BY 阅读全文
posted @ 2013-11-02 10:58 John_ABC 阅读(230) 评论(0) 推荐(0) 编辑
