桌子
輸出：
彩色參考輸出
在此處輸入影像描述
當我從 cycleTable 傳遞 ID 以獲取 cyc_id 然后將 cyc_id 傳遞給 LineTable 以獲取 LN_ID 時，如何獲取輸出。我想獲取具有最大 cyc_id 的可用 LN_NO 的所有 LN_ID。
uj5u.com熱心網友回復：
以下查詢產生您想要的輸出。
SELECT LN_ID
FROM table
WHERE CYC_ID =
(SELECT CYC_ID
FROM table
WHERE LN_ID = (SELECT MAX(LN_ID) FROM table))
uj5u.com熱心網友回復：
你解釋了它；剩下要做的就是將單詞翻譯成幾行代碼。這是一種選擇：
樣本資料：
SQL> with
2 cycle_table (cyc_id, id) as
3 (select 1002001, 1000000 from dual union all
4 select 1002002, 1000000 from dual union all
5 select 1002003, 1000001 from dual union all
6 select 1002004, 1000001 from dual
7 ),
8 line_table (ln_id, cyc_id, ln_no) as
9 (select 1002009, 1002004, 1 from dual union all
10 select 1002004, 1002002, 1 from dual union all
11 select 1002006, 1002003, 1 from dual union all
12 select 1002005, 1002002, 1 from dual union all
13 select 1002002, 1002001, 1 from dual union all
14 select 1002010, 1002004, 1 from dual union all
15 select 1002007, 1002003, 2 from dual union all
16 select 1002034, 1002002, 2 from dual union all
17 select 1002033, 1002002, 2 from dual union all
18 select 1002003, 1002001, 2 from dual union all
19 select 1002012, 1002004, 2 from dual union all
20 select 1002011, 1002004, 2 from dual union all
21 select 1002013, 1002004, 3 from dual union all
22 select 1002014, 1002004, 3 from dual union all
23 select 1002008, 1002003, 3 from dual
24 )
您可能感興趣的查詢：
25 --
26 select l.ln_id
27 from line_table l
28 where l.cyc_id in (select max(c.cyc_id)
29 from cycle_table c
30 where c.id = &par_id
31 );
Enter value for par_id: 1000000
LN_ID
----------
1002004
1002005
1002034
1002033
SQL> /
Enter value for par_id: 1000001
LN_ID
----------
1002009
1002010
1002012
1002011
1002013
1002014
6 rows selected.
SQL>
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/406865.html
標籤：
上一篇：用x值計算行數node.js