在线等你，问个问题!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- SQL code
姓名 年龄 金额张小姐 20 121李小姐 25 254陈小姐 30 365
统计年龄小于等于25岁以下的，金额
[解决办法]
- SQL code
USE tempdbcreate table mytest( [name] nvarchar(10), age int, price numeric(12))insert into mytest([name],age,price) values ('张小姐','20','121')insert into mytest([name],age,price) values ('李小姐','25','254')insert into mytest([name],age,price) values ('陈小姐','30','365')select * from mytest where age <=25SELECT sum(price) as valprice from mytest where age <=25/*375*/