SELECT a.examine_id examineId,a.examine_name examineName,a.level_limit levelLimit 				
FROM c_examinepaper a,
	(SELECT examine_id FROM c_examinepaper WHERE level_limit=? AND status=1
	MINUS
	SELECT DISTINCT examine_id FROM course) b             
WHERE a.examine_id = b.examine_id 		 	

---------------------------
SELECT a.examine_id AS examineId, a.examine_name AS examineName, a.level_limit AS levelLimit
FROM c_examinepaper a, (
		SELECT examine_id
		FROM c_examinepaper
		WHERE level_limit = ?
			AND status = 1
		MINUS
		SELECT DISTINCT examine_id
		FROM course
	) b
WHERE a.examine_id = b.examine_id
