带where子句的SQL MIN函数 [英] SQL MIN Function with where clause

问题描述

这是我的项目表

 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)

这篇关于带where子句的SQL MIN函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！