INSERT INTO用于向表中插入数据,每个值分别对应表中的字段。 3. 执行子查询并尝试使用ORDER BY 现在我们尝试执行一个子查询,并在子查询中使用ORDER BY语句: SELECT*FROM(SELECTname,salaryFROMemployeesWHEREdepartment='Engineering'ORDERBYsalaryDESC)ASsorted_engineers; 1. 2. 3. 解释: 这个查询意图从employees表中...
解决方案: select * from (SELECT * FROM article WHERE is_top=0 ORDER BY id DESC limit 999999) as t1 union select * from (SELECT * FROM article WHERE is_top=1 ORDER BY start_time desc limit 999999) as t2