SELECT u.VIDEO_ID
FROM T_USER_LEARNING_RECORD AS u ,
dbo.T_VIDEO AS v
WHERE u.VIDEO_ID = v.VIDEO_ID
AND u.LEARNING_TIME >= v.TIME_LENGTH
AND u.USER_ID = @user_id
SELECT VIDEO_ID FROM dbo.T_VIDEO WHERE COURSE_ID=@course_id
上面兩個sql語句都是找VIDEO_ID的，怎么在數(shù)據(jù)庫中寫一個函數(shù)判斷一個查找到的集合是不是在另一個查找的集合里面，怎么去實現(xiàn)？函數(shù)兩個參數(shù)@user_id、? @course_id
求一個sql函數(shù)。。。。萬分感謝
肥皂起泡泡
2018-12-06 23:37:12
