随笔分类 -  MSSQL

摘要：查询出数据表中第30条到第40条记录。ID为关键字段，同时ID不是连续的。答案：T-SQL语法select top 10 * from table where id>(select max(id) from (select top 30 id from table order by id) as tmptable) order by idMYSQL数据库SQL语法select id from tbl where id>(select max(id) from (select id from tbl order by id limit 0,10) as tmptable) order 阅读全文

摘要：Select CONVERT(varchar(100), GETDATE(), 23)---------------------Select CONVERT(varchar(100), GETDATE(), 4): 16.05.06Select CONVERT(varchar(100), GETDATE(), 5): 16-05-06Select CONVERT(varchar(100), GETDATE(), 6): 16 05 06Select CONVERT(varchar(100), GETDATE(), 7): 05 16, 06Select CONVERT(varchar(100) 阅读全文