sql取最小值

[qq_22405101]

SELECT PrjCode,U_keypoi,U_ystq FROM OPRJ INNER JOIN [@PM2] AS a ON a.DocEntry=oprj.U_prjnum WHERE a.U_status IS NULL AND Min(U_stepid) AND a.U_fzr ='Arthur'

U_stepid 这个值我要取最小值，我上面那种方式不对，请问有没有什么方式能实现了

[卖水果的net]

Min(U_stepid) 你这是要做什么呢？

[qq_22405101]

引用 2 楼 kingtiy 的回复:

SELECT  PrjCode ,
        U_keypoi ,
        U_ystq
FROM    OPRJ
        INNER JOIN [@PM2] AS a ON a.DocEntry=oprj.U_prjnum
WHERE   a.U_status IS NULL
        AND oprj.U_stepid=(SELECT MIN(U_stepid) FROM tb_xxx) --U_stepid是哪个表,你自己确定.
        AND a.U_fzr='Arthur'

感谢，就是这样的

[唐诗三百首]

需提供2个表的表结构,测试数据和希望结果, 才能帮你写SQL喔.

[kingtiy]

SELECT  PrjCode ,
        U_keypoi ,
        U_ystq
FROM    OPRJ
        INNER JOIN [@PM2] AS a ON a.DocEntry=oprj.U_prjnum
WHERE   a.U_status IS NULL
        AND oprj.U_stepid=(SELECT MIN(U_stepid) FROM tb_xxx) --U_stepid是哪个表,你自己确定.
        AND a.U_fzr='Arthur'