SQLServer常用简单语句

SQL Server

• 建表SQL

create table HIS_REQUEST
(
PAT_NAME nvarchar(20),
PHYSI_SEX_NAME nvarchar(6),
DATE_BIRTH nvarchar(20),
OUTHOSP_NO VARCHAR(20),
INHOSP_NO VARCHAR(20)
)

• 删除表，保留前十条/后十条数据

-- 保留前十条
DELETE table_name WHERE ID not in (SELECT TOP 10 ID from table_name ORDER BY ID )
-- 保留后十条
DELETE table_name WHERE ID not in (SELECT TOP 10 ID from table_name ORDER BY ID DESC)

• 删除表中前十条/后十条数据

-- 上面两条SQL去掉not即可
DELETE table_name WHERE ID in (SELECT TOP 10 ID from table_name ORDER BY ID )
DELETE table_name WHERE ID in (SELECT TOP 10 ID from table_name ORDER BY ID DESC)