The role of the following statements is:

SELECT ename, sal FROM emp

WHERE sal<(SELECT min (sal) FROM emp) + 1000.

A. displays information about the employee salary less than 1000 yuan

B. will employee salary less than 1000 yuan of salary increase after 1000 shows

C. show that more than the minimum wage of 1000 yuan of employee information

D. show no more than the minimum wage of 1000 yuan of employee information

CodePudding user response:

D

Other: simple SQL, if you don't understand that you will have endless questions to ask

CodePudding user response:

SELECT ename, sal FROM emp

WHERE sal<(SELECT min (sal) FROM emp) + 1000.

A. displays information about the employee salary less than 1000 yuan
SELECT ename, sal FROM emp
WHERE sal & lt; 1000;
B. will employee salary less than 1000 yuan of salary increase after 1000 shows
SELECT ename, sal + 1000 FROM emp
WHERE sal & lt; 1000;
C. show that more than the minimum wage of 1000 yuan of employee information
SELECT ename, sal FROM emp
WHERE sal<(SELECT min (sal) FROM emp) + 1000.
D. show no more than the minimum wage of 1000 yuan of employee information
SELECT ename, sal FROM emp
WHERE sal> (SELECT min (sal) FROM emp) + 1000.

CodePudding user response:

refer to the second floor AHUA1001 response:

SELECT ename, sal FROM emp

WHERE sal<(SELECT min (sal) FROM emp) + 1000.

A. displays information about the employee salary less than 1000 yuan
SELECT ename, sal FROM emp
WHERE sal & lt; 1000;
B. will employee salary less than 1000 yuan of salary increase after 1000 shows
SELECT ename, sal + 1000 FROM emp
WHERE sal & lt; 1000;
C. show that more than the minimum wage of 1000 yuan of employee information
SELECT ename, sal FROM emp
WHERE sal<(SELECT min (sal) FROM emp) + 1000.
D. show no more than the minimum wage of 1000 yuan of employee information
SELECT ename, sal FROM emp
WHERE sal> (SELECT min (sal) FROM emp) + 1000.

brother, 3 and 4 is greater than and less than you should change the position

CodePudding user response:

reference 3 floor Mricoo_ weeks response:

Quote: refer to the second floor AHUA1001 response:

SELECT ename, sal FROM emp

WHERE sal<(SELECT min (sal) FROM emp) + 1000.

A. displays information about the employee salary less than 1000 yuan
SELECT ename, sal FROM emp
WHERE sal & lt; 1000;
B. will employee salary less than 1000 yuan of salary increase after 1000 shows
SELECT ename, sal + 1000 FROM emp
WHERE sal & lt; 1000;
C. show that more than the minimum wage of 1000 yuan of employee information
SELECT ename, sal FROM emp
WHERE sal<(SELECT min (sal) FROM emp) + 1000.
D. show no more than the minimum wage of 1000 yuan of employee information
SELECT ename, sal FROM emp
WHERE sal> (SELECT min (sal) FROM emp) + 1000.

brother, 3 and 4 is greater than and less than you should change the position of

Oh oh, yes and yes, excited,

CodePudding user response:

Where sal less than the minimum wage) (+ 1000, is a D