¼òµ¥µÄSQLÎÊÌ⣡

SQL code:

declare @t1 table(ÊýÖµ decimal(10,2))
insert into @t1 values(200)
insert into @t1 values(150)
insert into @t1 values(199)
insert into @t1 values(200)

select sum(ÊýÖµ)as a ,a*2 as b from @t1


ÏëÒªµÄ½á¹û
===========================================
a b
749.00 1498.00
===========================================

¸ÄSQLÓï¾äÖÐÔÚ²éѯ·ÖÎöÆ÷ÖÐÌáʾ£ºÁÐÃû 'a' ÎÞЧ¡£
Çë´ó¼Ò°ï棡

---

SQL code:
select sum(ÊýÖµ)as a ,sum(ÊýÖµ)*2 as b from @t1

---

select a, a*2 from (select sum(ÊýÖµ)as a    from @t1) m

---

SQL code:
declare @t1 table(ÊýÖµ decimal(10,2))
insert into @t1 values(200)
insert into @t1 values(150)
insert into @t1 values(199)
insert into @t1 values(200)

select sum(ÊýÖµ)as a ,sum(ÊýÖµ)*2 as b from @t1

/*
a b
---------------------------------------- ----------------------------------------
749.00 1498.00

£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freewa