union order by

SELECT * FROM (
            SELECT TOP 10 * FROM Questions where q_type=1
            ) aa
UNION ALL

SELECT * FROM (
            SELECT TOP 10 * FROM Questions ORDER BY q_answer_num
              ) bb

posted @ 2008-10-25 14:08  袁雷  阅读(266)  评论(0)    收藏  举报