灵活的运用别名

xiaoxiao2021-02-28  20

在Oracle中使用别名

SELECT REPLACE(R,'3','P'),DNAME FROM (        SELECT REPLACE(M,'4','R') R,DNAME FROM (               SELECT  REPLACE(A,'9','M') M,DNAME FROM (                       SELECT REPLACE(DSFZ,'1','A') A,DNAME FROM TB_DENGJI WHERE DNAME = '769063402'                   )          ) )

转载请注明原文地址: https://www.6miu.com/read-1650023.html

最新回复(0)