这里，您将会显示出各个部门，这些部门是根据它们的部门号进行分类的。

Here, you will display departments, sorted by their department Numbers.

youdao

为了查看一个范例，创建一个返回部门号以及部门名，由部门所在地过滤结果的查询。

To see an example, create a query that returns a list department Numbers and names, filtered by their locations.

youdao

部门列表将会显示出来，V根据部门号进行排序，同时显示的还有部门中的员工列表(图33)。

The list of departments will display, ordered by department number, along with all of the list of employees in that department (Figure 33).

youdao

在第一个会话中，执行清单16中的update语句，它对部门号为B01的部门行设置独占锁。

In the first session, execute the UPDATE statement shown in Listing 16, which places an exclusive lock on the row with department number B01.

youdao

在第二个会话中，更新部门号为E11的行，然后试着更新部门号为B01的行，如清单17所示。

In a second session, update another row with department number E11 before trying to update the row for department B01, too, as shown in Listing 17.

youdao

考虑到它的目的，您只关心在您的列表中每个部门的简要概述，例如部门号，部门名，以及部门员工。

For this purpose, you are only concerned with seeing a brief summary of each department in your list, such as the department Numbers, names, and employees.

youdao

考虑到它的目的，您只关心在您的列表中每个部门的简要概述，例如部门号，部门名，以及部门员工。

For this purpose, you are only concerned with seeing a brief summary of each department in your list, such as the department Numbers, names, and employees.

youdao