CREATEOR REPLACE VIEW "SHLHSDE"."V_XDS1" ("A2","FX","XH","GJZ",
"ID_"
AS
select A2,concat(A1,substr(A2,1,(length(A2)-4))) fx,
to_number(substr(A2,-2,4)) xh,gjz,concat(A1,substr(A2,1,
(length(A2)-4)))||to_number(substr(A2,-2,4)) id_
from hds2@shlhsde2db
现在我要视图按照FX分组,按照XH排序,后面的SQL如何写?
|