带where子句的SQL MIN函数

本文介绍了带where子句的SQL MIN函数的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

这是我的项目表

Project Table JNo Name City J1 Proj1 London J2 Proj2 Paris J3 Proj3 Athens J4 Proj4 India

这是我的发货表

Shipment SNo PNo JNo Qty S1 P1 J1 50 S1 P1 J2 90 S1 P2 J1 40 S1 P3 J3 20 S2 P1 J3 110 S2 P2 J2 30 S2 P4 J3 10 S2 P3 J1 100 S3 P1 J3 80 S3 P4 J2 70 S3 P4 J2 70 S4 P1 J3 20 S4 P2 J1 60

我想说出供应最少数量的项目的名称.

I want to name of the project having minimum quantity supplied.

我尝试过.但是它只返回最小数量值 这是我的代码

I tried. But its return only minimum qty value this is my code

select min(qty) from shipment where jno IN(select jno from project)

推荐答案

SELECT p.name FROM Project p, Shipment s WHERE s.JNo = p.JNo AND s.Qty in (SELECT MIN(qty) FROM shipment)