可不可以在本select中引用一个新生成的字段。

select   card_id,sum(cent)as   'cent',select(sum(usecent)from   usecent)   as   'usecent',这后面还想加一个（sum(cent)-select(sum(usecent)from   usecent)   ）as'剩余分'  
  from   card  
  group   by   card_id  
  order   by   select(sum(usecent)from   usecent)  
   
  我总感觉写的麻烦了一些，这里的select(sum(usecent)from   usecent可不可以用一个什么名，直接去引用它呢 问题点数：0、回复次数：8Top

1 楼hdslah（）回复于 2003-09-02 08:03:10 得分 0

好象不行Top

2 楼pengdali（）回复于 2003-09-02 08:07:17 得分 0

 
  select   *,cent-usecent   剩余分   from(  
  select   card_id,sum(cent)   cent,sum(usecent)   usecent   from   card  
  group   by   card_id)   tem  
  order   by   usecentTop

3 楼zarge（鲨去来兮）回复于 2003-09-02 08:12:28 得分 0

select   card_id,sum(cent)   cent,sum(usecent)   usecent   sum(cent)   -   sum(usecent)  
  from   card  
  group   by   card_id  
  order   by   usecent  
  Top

4 楼zarge（鲨去来兮）回复于 2003-09-02 08:13:40 得分 0

更正一下：  
   
  select   card_id,   sum(cent)   cent,   sum(usecent)   usecent,    
          sum(cent)-sum(usecent)   as   剩余分  
  from   card  
  group   by   card_id  
  order   by   usecentTop

5 楼friendliu（无为）回复于 2003-09-02 08:15:43 得分 0

用表的嵌套Top

6 楼handyworkroom（瀚迪）回复于 2003-09-03 21:26:05 得分 0

不对呀，重新看清楚，usecent是usecent(同名表)中的一个字段，并不是card表中的字段呀，Top

7 楼zjcxc（邹建）回复于 2003-09-03 21:48:40 得分 0

可以用嵌套  
   
  select   *,cent-usercent   as   '剩余分'   from(  
  select   card_id,sum(cent)as   'cent',select(sum(usecent)from   usecent)   as   'usecent'  
  from   card  
  group   by   card_id)   a  
  order   by   usecent  
  Top

8 楼zarge（鲨去来兮）回复于 2003-09-03 22:33:05 得分 0

select   card_id,   cent,   usecent,   cent   -   usecent   as   剩余分  
  From  
  (select   card_id,   sum(cent)   as   cent,(select   sum(usecent)   from   usecent)   as   usecent  
  from   card  
  group   by   card_id)   t  
  order   by   usecentTop

相关问题

• 字段
• usecent
• cent
• cardgroup
• sum
• idorder
• card
• 剩余分
• select

• 帖主：handyworkroom

• SQL Server类图书