emp

emp

emp列表

• 杭州软件ORACLE面试题

  数据库实战有三张表：table dep（dep_id number(2), //部门编号dep_name varchar2(10)) //部门名称table emp (emp_id number(6), //员工编号emp_name varchar2(20),... [emp]

• 如何找出EMP表里面SALARY第N高的employee

  SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal... [emp]