informix怎么出来。总数不是60吗
解决方案 »
- Excel 与 CreateObject("Excel.Application") 问题
- 中文分词后如何建立索引
- 发布软件时候,给用户一个脚本.SQL安装
- 以javascript为脚本的ASP程序如何调用存储过程(有记录集的)?
- SQL7.0如何恢复MDF/LDF?
- 请问维护计划与备份数据库有什么区别呢?他们都能备份数据库啊
- 简单问题,新建指定间隔数的表
- 关于数据库连接
- 来者有分,一个关于导出sql脚本的问题,请进……
- mysql 怎么统计模糊查询的结果?
- 请问在asp中用windows模式登陆sqlserver时如何写ado的连接字符串?
- 一个关于sqlserver 2000 的全文检索的问题
SELECT SupplierName
FROM Supplier
WHERE SupplierID IN (
SELECT SupplierID
FROM Order
WHERE OrderID NOT IN (
SELECT OrderID
FROM OrderItem
GROUP BY OrderID HAVING SUM(Requested) < 70))
筛选得功能
回家耍去也
2.
SELECT a.SupplierName
from (select OrderID
from Supplier
group by OrderID
having isnull(sum(Requested),0)>=70) a,[Order] b,OrderItem c
where a.OrderID=b.OrderID and b.SupplierID=c.SupplierID
union
select d.SupplierName
from Supplier d
where not exists (select *
from [Order] e
where d.SupplierID=e.SupplierID)
Oracle 1
IBM 1
Informix 0
Microsoft 0The solution must work with SQL-92.