Java面试常用知识点总结 — 数据库部分
(PDF资源:https://download.csdn.net/download/qq_36254699/11577742 )
1、SQL 基础
2、有一组合索引(A,B,C) ,会出现哪几种查询方式?tag:sql 语句
考察点: sql 语句
参考回答:
优: select * from test where a=10 and b>50
差: select * from test where b = 50
优: select * from test order by a
差: select * from test order by b
差: select * from test order by c
优: select * from test where a=10 order by a
优: select * from test where a=10 order by b
差: select * from test where a=10 order by c
优: select * from test where a>10 order by a
差: select * from test where a>10 order by b