E。 select dept_id， job_cat，max(salary) from employees group by dept_id，job_cat，salary;

神州数码笔试4)in a select statement that includes a where clause，where is the group by clause placed in the select statement?______。

A。 immediately after the select clause

B。 before the where clause

C。 before the from clause

D。 after the order by clause

E。 after the where clause

神州数码笔试5)in a select statement that includes a where clause，where is the order by clause placed in the select statement?______。

A。immediately after the select clause

B。before the where clause

C。after all clause

D。after the where clause

E。before the from clause

神州数码笔试6)evaluate there two sql statements______。

Select last_name，salary from employees order by salary;

Select last_name，salary from employees order by 2 asc;

A。the same result B。different result C。the second statement returns a syntax error

神州数码笔试7) you would like to display the system date in the format“20051110 14：44：17”。Which select statement should you use?______。