(SELECT person, amount FROM sales2005 WHERE amount=1000)
UNION
(SELECT person, amount FROM sales2005 WHERE person LIKE 'Сергей')

(SELECT person, amount FROM sales2005 WHERE amount=1000 order by person)
UNION
(SELECT first 1 person, amount FROM sales2005 WHERE person LIKE 'Сергей'  order by person desc)

 { <query_specification> | ( <query_expression> ) } 
  UNION [ ALL ] 
  <query_specification | ( <query_expression> ) 
 [ UNION [ ALL ] <query_specification> | ( <query_expression> ) 
    [ ...n ] ] 

<SELECT statement> ::=  
    [WITH <common_table_expression> [,...n]]
    <query_expression> 
    [ ORDER BY { order_by_expression | column_position [ ASC | DESC ] } 
  [ ,...n ] ] 
    [ <FOR Clause>] 
    [ OPTION ( <query_hint> [ ,...n ] ) ] 
<query_expression> ::= 
    { <query_specification> | ( <query_expression> ) } 
    [  { UNION [ ALL ] | EXCEPT | INTERSECT }
        <query_specification> | ( <query_expression> ) [...n ] ] 
<query_specification> ::= 
SELECT [ ALL | DISTINCT ] 
    [TOP ( expression ) [PERCENT] [ WITH TIES ] ] 
    < select_list > 
    [ INTO new_table ] 
    [ FROM { <table_source> } [ ,...n ] ] 
    [ WHERE <search_condition> ] 
    [ <GROUP BY> ] 
    [ HAVING < search_condition > ] 

<query_expression> ::= 
    { <query_specification> | ( <query_expression> ) } 
    [  { UNION [ ALL ] | EXCEPT | INTERSECT }
        <query_specification> | ( <query_expression> ) [...n ] ] 

(SELECT person, amount FROM sales2005 WHERE amount=1000)
UNION
select first 1 ... from (
    (SELECT person, amount FROM sales2005 WHERE amount=1000)
    UNION
    (SELECT person, amount FROM sales2005 WHERE person LIKE 'Сергей')
  order by 1)
)

<query_expression> ::=
     { <query_specification> | ( <query_expression> ) } 

select A, B
from ...
ORDER BY C

select WI_Shops_ID, coalesce(FindContr_ID, Contr_ID) as Contr_ID, cast(DateFrom as date) as DateFrom,
count(*) as all_count, 
sum(iif(b_IsBit(Flags, 2) = 1 and b_IsBit(Flags, 10) = 0, 1, 0)) as new_count, 
sum(iif(b_IsBit(Flags, 4) = 1, 1, 0)) as old_count, 
sum(iif(b_IsBit(Flags, 6) = 1, 1, 0)) as find_count,
min((
  select first 1 ValueData from 
  (
  select ValueData from (select ValueData from Banker_Price where TypeID = 2 and DateFrom <= H.DateFrom and 
    WI_Shops.Banker_ID = Banker_ID and Seller_ID = WI_Shops.Seller_ID and SellerAddr_ID = WI_Shops.SellerAddr_ID
    order by Banker_ID desc, Seller_ID desc, SellerAddr_ID desc, TypeID desc, DateFrom desc)
    group by 1     
  union all
  select ValueData from (select ValueData from Banker_Price where TypeID = 2 and DateFrom <= H.DateFrom and
    WI_Shops.Banker_ID = Banker_ID and Seller_ID = WI_Shops.Seller_ID and SellerAddr_ID is null
    order by Banker_ID desc, Seller_ID desc, SellerAddr_ID desc, TypeID desc, DateFrom desc)     
  union all
  select ValueData from (select ValueData from Banker_Price where TypeID = 2 and DateFrom <= H.DateFrom and
    WI_Shops.Banker_ID = Banker_ID and Seller_ID is null and SellerAddr_ID is null
    order by Banker_ID desc, Seller_ID desc, SellerAddr_ID desc, TypeID desc, DateFrom desc)     
  ) )) as Price01,
min((select first 1 ValueData from 
  (select ValueData from (select ValueData from Banker_Price where TypeID = 3 and DateFrom <= H.DateFrom and
    WI_Shops.Banker_ID = Banker_ID and Seller_ID = WI_Shops.Seller_ID and SellerAddr_ID =WI_Shops.SellerAddr_ID
    order by Banker_ID desc, Seller_ID desc, SellerAddr_ID desc, TypeID desc, DateFrom desc)     
  union all
  select ValueData from (select ValueData from Banker_Price where TypeID = 3 and DateFrom <= H.DateFrom and
    WI_Shops.Banker_ID = Banker_ID and Seller_ID = WI_Shops.Seller_ID and SellerAddr_ID is null
    order by Banker_ID desc, Seller_ID desc, SellerAddr_ID desc, TypeID desc, DateFrom desc)     
  union all
  select ValueData from (select ValueData from Banker_Price where TypeID = 3 and DateFrom <= H.DateFrom and
    WI_Shops.Banker_ID = Banker_ID and Seller_ID is null and SellerAddr_ID is null
    order by Banker_ID desc, Seller_ID desc, SellerAddr_ID desc, TypeID desc, DateFrom desc)     
  ) )) as Price02
from H_Req H, WI_Shops where H.WI_Shops_ID = WI_Shops.ID 
group by 1, 2, 3