sqlservler常用命令

查看头5条数据

select top 5 * from tb_Log

查看后5条数据

select top 5 * from tb_Log  ORDER BY InsertTime DESC

删除前5条数据

DELETE TOP(5) from tb_Log

删除后5条数据

DELETE  from tb_Log WHERE InsertTime in( select top 5 InsertTime from tb_Log  ORDER BY InsertTime DESC)