A limit order can be devided into sell limit order and buy limit order.
举一反三
- A buy limit order can only be executed at the limit price or lower.
- 下列语句中正确的是（） A: DELETE < > [WHERE 筛选条件] [ORDER BY 子句] [LIMIT 子句] B: DELETE [WHERE 筛选条件] [ORDER BY 子句] [LIMIT 子句] C: DELETE [ORDER BY 子句] D: DELETE FROM < > [WHERE 筛选条件] [ORDER BY 子句] [LIMIT 子句]
- 查询主键id从高到低排序的前10条记录的语句是（） A: SELECT * FROM table ORDER BY id ASC limit 1,10 B: SELECT * FROM table ORDER id DESC limit 10 C: SELECT * FROM table ORDER BY id DESC limit 10 D: SELECT * FROM table ORDER id ASC limit 1,10
- 在stud表中返回年龄最小的8位同学的信息，使用（)。 A: A.SELECT * FROM stud ORDER BY birthday DESC LIMIT 8; B: B.SELECT * FROM stud ORDER BY birthday ASC LIMIT 8; C: C.SELECT * FROM stud ORDER BY birthday ASC LIMIT 7; D: D.SELECT * FROM stud ORDER BY birthday DESC LIMIT 7;
- In order to limit the devaluation of the domestic currency caused by the hedge fund, a central bank need _________.