现有一视图“V_PXAA_ST01”，我想在查询的时候，给查询出来的列起别名，sql如下
SELECT ID as "id",
pCount as "pcount",
address as "address",
XXSB_ZRR_CODE as "xxsbZrrCode",
xxsbZrr as "xxsbZrr",
SECOND_YWJBR_CODE as "secondYwjbrCode",
secondYwjbr as "secondYwjbr",
CONSIGNER_CODE as "consignerCode",
consignerName as "consignerName",
bidName as "bidName",
bidContent as "bidContent",
lastConsignMoney as "lastConsignMoney",
currentConsignMoney as "currentConsignMoney",
CONSIGN_CODE as "consignCode",
CONSIGN_DATE as "consign_date",
consignDate as "consignDate",
auditDate as "auditDate",
bidCode as "bidCode",
fileSumbitDate as "fileSumbitDate",
filePassDate as "filePassDate",
noticeDate as "noticeDate",
bidOpenDate as "bidOpenDate",
resultDate as "resultDate",
supplierNames as "supplierNames",
feeType as "feeType",
commissionPrice as "commissionPrice",
commission as "commission",
remark as "remark"
FROM V_PXAA_ST01
WHERE 1 = 1
ORDER BY ID desc
但是会报错，求教学！