例题:有一个计费表,表名jifei,字段如下:phone(8位的电话号码),month(月份),expenses(月消费,费用为0表明该月没有产生费用) 下面是该表的一条记录:64262631,201011,30.6 这条记录的含义就是64262631的号码在2010年11月份产生了30.6元的话费。 按照要求写出满足下列条件的sql语句:
1
select distinct phone from jifei where (month in (201007,201008,201009) and month not in (201009,201010)) and expenses between 51 and 100
1
select distinct phone from jifei where mid(phone,5,1)=mid(phone,6,1) and mid(phone,7,1)=mid(phone,8,1) and mid(phone,5,1) \<> mid(phone,7,1)
1
select identity(int,1,1) as id, _into new_table from jifei; delete from new_table where (phone,month,expenses) in (select phone,month,expenses from new_table group by phone,month,expenses having count(_) > 1) and id not in (select min(id) from new_table group by phone,month,expenses having count(\*) > 1);
1
select distinct phone from jifei where (month in (201009,201010)) and (expenses > 30)
設第一張成本價爲x,(60-x)/x=0.2,x=50 第二張成本價爲y,(60-y)/y=-0.2,y=75 總體盈虧:120-(50+75)= -5 亏损5元
一人一半,因为不论二人效率和速度如何,都负责耕种了一半的土地
1 11 21 1211 111221
下一行是什么?312211 13112221
先同时点燃两根绳子,A两头都点燃,B点燃一头,当A烧完时开始点燃B的另一头,此时用时30分钟,当B烧完时拿出绳子C,两头都点(此时用时45分钟),当绳子C烧完时刚好用时一小时十五分钟。