lte01 AS [ID] ,lte03 AS [采样时间] ,lte04 AS [标本号] ,lte05 AS [标本序号] ,lte09 AS [申请日期] ,lte10 AS [1=紧急] ,lte16 AS [病人条码] ,lte24 AS [大量, 特殊, 储备, 其他] ,lte25 AS [单位献血证, 个人献血证, 无献血证] ,lte34 AS [1:待上级医师审核2:审核完成3:输血完成4:待科室主任审批5:待医务部审批] ,lte35 AS [说明] ,lte38 AS [登记时间] ,lte41 AS [审核时间] ,lte43 AS [打印时间] ,lte45 AS [人工费] ,lte46 AS [总费用] ,lte06 AS [输血史1无,2有] ,lte49 AS [用血性质] ,lte55 AS [是否大量用血(0:否 1大量用血 2:超大用血)] ,lte56 AS [配血完成标识,1已配血] ,lte57 AS [手术用血级别] ,lte58 AS [输血相关体征] ,lte59 AS [不良反应史]
时间: 2023-08-18 16:54:24 浏览: 91
好的,以下是使用给定的列别名表补全查询语句的示例:
```sql
SELECT
lte01 AS ID,
lte03 AS 采样时间,
lte04 AS 标本号,
lte05 AS 标本序号,
lte09 AS 申请日期,
lte10 AS 是否紧急,
lte16 AS 病人条码,
lte24 AS 大量_特殊_储备_其他,
lte25 AS 献血证类型,
lte34 AS 状态,
lte35 AS 说明,
lte38 AS 登记时间,
lte41 AS 审核时间,
lte43 AS 打印时间,
lte45 AS 人工费,
lte46 AS 总费用,
lte06 AS 输血史,
lte49 AS 用血性质,
lte55 AS 是否大量用血,
lte56 AS 配血完成标识,
lte57 AS 手术用血级别,
lte58 AS 输血相关体征,
lte59 AS 不良反应史
FROM 表名;
```
请将上述的"表名"替换为您要查询的实际表名,并将此查询语句用于您的POSTGRESQL数据库。
阅读全文