|
- ;with maco as
- (
- select number from master..spt_values
- where type='p' and number between 1 and 100
- )
- select
- a.number as 鸭蛋数,b.number as 鸡蛋数,c.number as 鸟蛋数
- from maco a,maco b,maco c
- where a.number+b.number+c.number=100 and a.number*4+b.number*3+c.number*0.1=100
- /*
- 鸭蛋数 鸡蛋数 鸟蛋数
- ----------- ----------- -----------
- 3 27 70
- */
复制代码 |
|