单选题Select雇员_ID FROMemployee WHERE薪水1250命令的功能是()。A查询薪水大于1250的记录B查询1250号记录后的记录C检索所有的雇员_IDD从[employee]关系中检索薪水大于1250的雇员_ID
单选题
Select雇员_ID FROMemployee WHERE薪水>1250命令的功能是()。
A
查询薪水大于1250的记录
B
查询1250号记录后的记录
C
检索所有的雇员_ID
D
从[employee]关系中检索薪水大于1250的雇员_ID
参考解析
解析:
暂无解析
相关考题:
下列哪个语句查出雇员表(employees)里的雇员名字(ename)是‘SMITH’的信息,并且给雇员名字(ename)列定义一个别名Name()。 A.select employeesno,ename Name,job from employees where ename=‘SMITH’B.select employeesno,ename ‘Name’,job from employees where ename=SMITHC.select employeesno,ename “Name”,job from employees where ename=‘SMITH’D.select employeesno,ename ‘Name’,job frome mployees wheree name=‘SMITH’
下面语句中,表示过虑条件是vend_id=1002或vend_id=1003的是( )A.select * from products where vend_id=1002 or vend_id=1003B.select * from products where vend_id in (1002,1003);C.select * from products where vend_id not in (1004,1005);D.select * from products where vend_id=1002 and vend_id=1003
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary KeyFIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)DEPARTMENT_ID NUMBERSALARY NUMBERWhat is the correct syntax for an inline view? ()A. SELECT a.last_name, a.salary, a.department_id, b.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary b.maxsal;B. SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))C. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);D. SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);
Examine the data in the EMPLOYEES table:Which three subqueries work? () A. SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);C. SELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);D. SELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);E. SELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);F. SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER(4)LAST_NAME VARCHAR2 (25)JOB_ID VARCHAR2(10)You want to search for strings that contain ‘SA_‘ in the JOB_ID column. Which SQL statement do you use?()A. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA\_%‘ESCAPE‘\‘;B. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_‘;C. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE ‘%SA_‘ESCAPE‘\‘;D. SELECT employee_id, last_name, job_id FROM employees WHERE job_id ‘%SA_‘;
Examine the data in the EMPLOYEES table:LAST_NAME DEPARTMENT_ID SALARYGetz 10 3000Davis 20 1500Bill 20 2200Davis 30 5000...Which three subqueries work? () A. SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);B. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);C. SELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);D. SELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);E. SELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);F. SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
Click the Exhibit button and examine the data in the EMPLOYEES table.Which three subqueries work? () A.SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department_id);B.SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);C.SELECT distinct department_id FROM employees WHERE salary ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);D.SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);E.SELECT last_name FROM employees WHERE salary ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);F.SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));
下列哪个语句查出雇员表(employees)里的雇员名字(ename)是‘SMITH’的信息,并且给雇员名字(ename)列定义一个别名Name()。A、select employeesno,ename Name,job from employees where ename=‘SMITH’B、select employeesno,ename ‘Name’,job from employees where ename=SMITHC、select employeesno,ename “Name”,job from employees where ename=‘SMITH’D、select employeesno,ename ‘Name’,job frome mployees wheree name=‘SMITH’
V5.x系统中,查询动环网管数据库中端局编号为102的端局名的SQL语句是()A、selct*from office where officeid=102B、select*form office where officeid=102C、select*form office where office_id=102D、select*from office where office_id=102
评估以下SELECT语句:SELECT雇员标识,姓氏,名字,薪金‘年薪’ FROM雇员 WHERE薪金ISNOTNULL ORDERBY姓氏,3;以下哪个子句有错误?()A、SELECT雇员标识,姓氏,名字,薪金’年薪’B、FROM雇员C、WHERE薪金IS NOT NULLD、ORDER BY姓氏,3;
下面哪条语句可以取出薪水最高的前三个人:()A、SELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY SALARY );B、SELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY SALARY ) WHERE ROWNUM=3;C、SELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY SALARY DESC) WHERE ROWNUM=3;D、SELECT * FROM EMPLOYEES WHERE ROWNUM=3 ORDER BY SALARY DESC;
“雇员”表包含以下列: 雇员标识NUMBER 姓氏VARCHAR2(25) 名字VARCHAR2(25) 部门标识NUMBER 职务标识NUMBER 经理标识NUMBER 薪金NUMBER(9,2) 佣金NUMBER(7,2) 聘用日期DATE 以下哪条SELECT语句可用于显示部门70中薪金最低的10位员工()A、SELECT ROWNUM"排名",姓氏,名字"雇员",薪金"薪金"FROM(SELECT 姓氏,名字,薪金 FROM 雇员ORDER BY 薪金)WHERE ROWNUM=10 AND job_id LIKE’CLERK’AND department_id=70B、SELECT ROWNUM"排名",姓氏,名字"雇员",薪金"薪金"FROM(SELECT 姓氏,名字,薪金,职务标识FROM 雇员 WHERE 职务标识 LIKE’CLERK’AND 部门标识=70ORDER BY 薪金)WHERE ROWNUM=10C、SELECT ROWNUM"排名",姓氏,名字"雇员",薪金"薪金"FROM(SELECT 姓氏,名字,薪金,职务标识,部门标识 FROM 雇员 WHERE ROWNUM=10ORDER BY 薪金)WHERE 职务标识 LIKE’CLERK’AND 部门标识=70D、唯一的方法是使用数据字典
Select雇员_ID FROMemployee WHERE薪水1250命令的功能是()。A、查询薪水大于1250的记录B、查询1250号记录后的记录C、检索所有的雇员_IDD、从[employee]关系中检索薪水大于1250的雇员_ID
命令“SELECT 职工号 FROM 职工 WHERE 工资1250”的功能是()。A、查询工资大于1250的纪录B、检索所有的职工号C、查询1250号记录后的记录D、从[职工]表中查询工资大于1250的职工号
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?()A、SELECT COUNT(*) FROM employees WHERE last_name='Smith';B、SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';C、SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';D、SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';E、SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid?()A、DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = 'carrey');
Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? ()A、SELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);B、SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);C、SELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);D、SELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);E、SELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);F、SELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
单选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER SALARY NUMBER What is the correct syntax for an inline view?()ASELECT a.last_name, a.salary, a.department_id,Bmaxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary b.maxsal;CSELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))DSELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);ESELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);
多选题Examine the data in the EMPLOYEES table: Which three subqueries work? ()ASELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);CSELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);DSELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);ESELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);FSELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
单选题“雇员”表包含以下列: 雇员标识NUMBER 姓氏VARCHAR2(25) 名字VARCHAR2(25) 部门标识NUMBER 职务标识NUMBER 经理标识NUMBER 薪金NUMBER(9,2) 佣金NUMBER(7,2) 聘用日期DATE 以下哪条SELECT语句可用于显示部门70中薪金最低的10位员工()ASELECT ROWNUM排名,姓氏,名字雇员,薪金薪金FROM(SELECT 姓氏,名字,薪金 FROM 雇员ORDER BY 薪金)WHERE ROWNUM=10 AND job_id LIKE’CLERK’AND department_id=70BSELECT ROWNUM排名,姓氏,名字雇员,薪金薪金FROM(SELECT 姓氏,名字,薪金,职务标识FROM 雇员 WHERE 职务标识 LIKE’CLERK’AND 部门标识=70ORDER BY 薪金)WHERE ROWNUM=10CSELECT ROWNUM排名,姓氏,名字雇员,薪金薪金FROM(SELECT 姓氏,名字,薪金,职务标识,部门标识 FROM 雇员 WHERE ROWNUM=10ORDER BY 薪金)WHERE 职务标识 LIKE’CLERK’AND 部门标识=70D唯一的方法是使用数据字典
单选题Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin placed his orders?()A SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Martin' AND ord_date IN ('18-JUL-2000','21-JUL-2000');B SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Martin'));C SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders, customers WHERE cust_name = 'Martin');D SELECT ord_id, cust_id, ord_total FROMorders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust_name = 'Martin');
单选题Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE NEW EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2 (60) Which DELETE statement is valid? ()ADELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);BDELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);CDELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'DDELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'
多选题Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work?()ASELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department_id);BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);CSELECT distinct department_id FROM employees WHERE salary ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);DSELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);ESELECT last_name FROM employees WHERE salary ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);FSELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));
单选题命令“SELECT 职工号 FROM 职工 WHERE 工资1250”的功能是()。A查询工资大于1250的纪录B检索所有的职工号C查询1250号记录后的记录D从[职工]表中查询工资大于1250的职工号
多选题Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? ()ASELECT * FROM employees where salary (SELECT MIN(salary) FROM employees GROUP BY department _ id);BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);CSELECT distinct department_id FROM employees Where salary ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);DSELECT department_id FROM employees WHERE SALARY ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);ESELECT last_name FROM employees Where salary ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);FSELECT department_id FROM employees WHERE salary ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));