有沒有大佬給個正確答案參考下
uj5u.com熱心網友回復：
第一題：SELECT
A .china_name,
COUNT (b.opr_state_id) AS kxjjsl
FROM
spc_room A,
rme_rack b
WHERE
b.opr_state_id = '170001'
AND A .is_supportide = 1
AND b.posit_id = A .room_id
GROUP BY
A .china_name
第二題：
SELECT
*
FROM
rme_port
WHERE
super_res_id IN (
SELECT
eqp_id
FROM
rme_eqp
WHERE
posit_id IN (
SELECT
room_id
FROM
spc_room
WHERE
A .is_supportide = 1
)
)
uj5u.com熱心網友回復：
第一題漏了個條件，應該是這樣：
uj5u.com熱心網友回復：
感謝uj5u.com熱心網友回復：
--題1
SELECT a.china_name,COUNT(b.opr_state_id) AS cnt
FROM spc_room AS a
INNER JOIN rme_rack AS b ON a.room_id=b.posit_id AND b.opr_state_id='170001'
WHERE a.issupportidc=1
HAVING COUNT(b.opr_state_id)>1000
--題2
--in
SELECT b.* FROM rme_eqp AS a
INNER JOIN rem_port AS b ON a.eqp_id=b.super_res_id
WHERE a.posid_id IN (
SELECT room_id FROM spc_room
WHERE issupportidc=1
)
--exists
SELECT b.* FROM rme_eqp AS a
INNER JOIN rem_port AS b ON a.eqp_id=b.super_res_id
WHERE exists (
SELECT room_id FROM spc_room AS c
WHERE issupportidc=1 AND a.posit_id = c.room_id
)
uj5u.com熱心網友回復：
SELECT a.china_name,COUNT(b.opr_state_id) AS cnt
FROM spc_room AS a
INNER JOIN rme_rack AS b ON a.room_id=b.posit_id AND b.opr_state_id='170001'
WHERE a.issupportidc=1
GROUP BY a.china_name
HAVING COUNT(b.opr_state_id)>1000
少了個分組條件
uj5u.com熱心網友回復：
公司沒有招人的計劃，但是還是在網上發了好多招聘廣告。把專案中遇到的，解決不了的問題，當作面試題。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/36535.html
標籤：基礎和管理
上一篇：大佬們看看這個為啥報錯