Select A from T where a=b and b=c and c=d

WITH MEMBER [ZQ1AUTCTR].[COG_OQP_INT_t1] AS '1', SOLVE_ORDER = 65535, MEMBER_CAPTION = '' MEMBER [ZQ1AUTCTR].[COG_OQP_INT_t2] AS '1', SOLVE_ORDER = 65535, MEMBER_CAPTION = '' MEMBER [ZQ1AUTCTR].[COG_OQP_INT_t3] AS '1', SOLVE_ORDER = 65535, MEMBER_CAPTION = '' MEMBER [ZQ1AUTCTR].[COG_OQP_INT_umg1] AS '([ZQ1AUTCTR].[All])', SOLVE_ORDER = 4, MEMBER_CAPTION = 'Aggregate(Country)' MEMBER [ZQ1AUTCTR].[COG_OQP_INT_umg2] AS '([ZQ1AUTCTR].[All])', SOLVE_ORDER = 4, MEMBER_CAPTION = 'Aggregate(Country (All))' SELECT {[Measures].[ZQ1AUTCOS]} DIMENSION PROPERTIES PARENT_LEVEL, CHILDREN_CARDINALITY ON AXIS(0), UNION(UNION(UNION(UNION(UNION(UNION([ZQ1AUTCTR].[LEVEL01].MEMBERS, {([ZQ1AUTCTR].[COG_OQP_INT_t1])}, ALL), {[ZQ1AUTCTR].[COG_OQP_INT_umg1]}, ALL), {([ZQ1AUTCTR].[COG_OQP_INT_t2])}, ALL), [ZQ1AUTCTR].[LEVEL00].MEMBERS, ALL), {([ZQ1AUTCTR].[COG_OQP_INT_t3])}, ALL), {[ZQ1AUTCTR].[COG_OQP_INT_umg2]}, ALL) DIMENSION PROPERTIES PARENT_LEVEL, CHILDREN_CARDINALITY ON AXIS(1) FROM [$ZQ1AUTC01]

SELECT {[Measures].[ZQ1AUTCOS]} DIMENSION PROPERTIES PARENT_LEVEL, CHILDREN_CARDINALITY ON AXIS(0), [ZQ1AUTCNT].[LEVEL01].MEMBERS DIMENSION PROPERTIES PARENT_LEVEL, CHILDREN_CARDINALITY ON AXIS(1) FROM [$ZQ1AUTC01]

Select (T1.C)as "D""C" from T join (Select 4 from D3) T1 on T1.A = T.C

Select T.A as V, "A"+T.B as "AA""CC", T1.C as "D" from T join (Select 4 from D3) T1 on T1.A = T.C

Select T.*, "A"+T.B, T1.C as "D" from T join (Select 4 from D3) T1 on T1.A = T.C

Select (A from B) from T where A=1

with Time_dimension6 as (select TIME_DIMENSION.DAY_KEY, TIME_DIMENSION.DAY_DATE, TIME_DIMENSION.MONTH_KEY, TIME_DIMENSION.CURRENT_MONTH, TIME_DIMENSION.QUARTER_KEY, TIME_DIMENSION.CURRENT_QUARTER, TIME_DIMENSION.CURRENT_YEAR, TIME_DIMENSION.DAY_OF_WEEK, TIME_DIMENSION.DAY_OF_MONTH, TIME_DIMENSION.DAYS_IN_MONTH, TIME_DIMENSION.DAY_OF_YEAR, TIME_DIMENSION.WEEK_OF_MONTH, TIME_DIMENSION.WEEK_OF_QUARTER, TIME_DIMENSION.WEEK_OF_YEAR, TIME_DIMENSION.WEEKDAY_EN as WEEKDAY, TIME_DIMENSION.MONTH_EN as MONTH1 from gosales...TIME_DIMENSION), Sales__model_ as (select (((extract(year from Order_header8.ORDER_DATE) * 10000) + (extract(month from Order_header8.ORDER_DATE) * 100)) + extract(day from Order_header8.ORDER_DATE)) as Day_key__order_date_, (Order_details7.QUANTITY * Order_details7.UNIT_SALE_PRICE) as Revenue from gosales...ORDER_DETAILS Order_details7, gosales...ORDER_HEADER Order_header8 where (Order_header8.ORDER_NUMBER = Order_details7.ORDER_NUMBER) ) select cast(Time_dimension9.CURRENT_YEAR as character (4)) as Yearkey, XSUM(Sales__model_.Revenue for cast(Time_dimension9.CURRENT_YEAR as character (4)) ) as Revenue from Time_dimension6 Time_dimension9, Sales__model_ where (Time_dimension9.DAY_KEY = Sales__model_.Day_key__order_date_) group by cast(Time_dimension9.CURRENT_YEAR as character (4))

select distinct PRODUCTLINE.PRODUCTLINE as PRODUCTLINE from GOSALES_ORACLE..GOSALES.PRODUCTLINE PRODUCTLINE

select distinct PRODUCTLINE.PRODUCTLINE as PRODUCTLINE, PRODUCTTYPE.PRODUCTTYPE as PRODUCTTYPE from GOSALES_ORACLE..GOSALES.PRODUCTLINE PRODUCTLINE, GOSALES_ORACLE..GOSALES.PRODUCTTYPE PRODUCTTYPE where (PRODUCTLINE.PRODUCTLINECODE = PRODUCTTYPE.PRODUCTLINECODE) order by PRODUCTLINE asc

select "Product_line13"."PRODUCT_LINE_CODE" AS "memberUniqueName2", min("Product_line13"."PRODUCT_LINE")AS "Product_line", sum("coguda10"."QUANTITY" * "coguda10"."UNIT_SALE_PRICE")AS "Revenue" from ( select "PRODUCT_LINE"."PRODUCT_LINE_CODE" AS "PRODUCT_LINE_CODE", min("PRODUCT_LINE"."PRODUCT_LINE_EN")AS "PRODUCT_LINE" from "PRODUCT_LINE" group by "PRODUCT_LINE"."PRODUCT_LINE_CODE" )"Product_line13", "ORDER_DETAILS" "coguda10", "ORDER_HEADER" "coguda11", ( select "PRODUCT"."PRODUCT_NUMBER" AS "PRODUCT_NUMBER", min("PRODUCT"."PRODUCT_TYPE_CODE")AS "PRODUCT_TYPE_CODE" from "PRODUCT" group by "PRODUCT"."PRODUCT_NUMBER" )"Product15", ( select "PRODUCT_TYPE"."PRODUCT_TYPE_CODE" AS "PRODUCT_TYPE_CODE", min("PRODUCT_TYPE"."PRODUCT_LINE_CODE")AS "PRODUCT_LINE_CODE" from "PRODUCT_TYPE" group by "PRODUCT_TYPE"."PRODUCT_TYPE_CODE" )"Product_type16" where "coguda11"."ORDER_NUMBER" = "coguda10"."ORDER_NUMBER" and "Product_line13"."PRODUCT_LINE_CODE" = "Product_type16"."PRODUCT_LINE_CODE" and "Product_type16"."PRODUCT_TYPE_CODE" = "Product15"."PRODUCT_TYPE_CODE" and "Product15"."PRODUCT_NUMBER" = "coguda10"."PRODUCT_NUMBER" group by "Product_line13"."PRODUCT_LINE_CODE"