Re: [SQL ] 資料庫資料比對的問題
※ 引述《pipibabe (pipi)》之銘言:
: ID PICID SCORE
: --------------------------
: 01 1 2
: 01 2 2
: 01 4 1
: 02 1 2
: 02 2 1
: 02 4 2
假設表格名稱是 mytable
SELECT *
FROM mytable
WHERE PICID IN (
SELECT DISTINCT a.PICID
FROM mytable a, mytable b
WHERE a.PICID = b.PICID
AND a.ID = '01'
AND b.ID = '02'
)
兩題做法雷同
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.36.40.229
推
02/12 23:29, , 1F
02/12 23:29, 1F
→
02/13 12:49, , 2F
02/13 12:49, 2F
→
02/13 12:54, , 3F
02/13 12:54, 3F
→
02/13 12:55, , 4F
02/13 12:55, 4F
討論串 (同標題文章)
本文引述了以下文章的的內容:
完整討論串 (本文為第 2 之 3 篇):