[Java]Java面试常用知识点总结 — 数据库部分（来自牛客资料）

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