0. 查询最高工资及其对应员工解法一: select ename from (select ename from emp order by sal desc) where rownum=1;解法二: select ename from emp where sal=(select max(sal) from emp);解法三: select ename, sal
栗子:定义一个数组,赋值十万条数据。然后分别使用四种方式遍历该数组、取出name不包含4的所有列表直接上代码,如下: public static void main(String[] args) throws Exception { List<IntegerIdAndNameEntity> list = new ArrayList<>(); for (int i = 1; i <= 10000