Examine the structure of the employees table.
You want to display the maximum and minimum salaries of employees hired 1 year ago.
Which two statements would get the correct output?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Which two statements would get the correct output?
Examine the structure of the employees table.
You want to display the maximum and minimum salaries of employees hired 1 year ago.
Which two statements would get the correct output?
A,C Option is correct, Verified.
ac
Passed 1Z0-061 exam recently!
Total 75 questions, few new questions, learned them from PassLeader 1Z0-061 dumps (http://www.passleader.com/1z0-061.html), which is 100% pass ensure now!
p.s.
Free PassLeader 1Z0-061 dumps from Google Drive:
https://drive.google.com/open?id=0B-ob6L_QjGLpZ2pPVDVMSlJ6UjA
Good Luck!
A, C
————————————————————————-
SELECT expression1, expression2, … expression_n,
aggregate_function (aggregate_expression)
FROM tables
[WHERE conditions]
GROUP BY expression1, expression2, … expression_n;
where
* expression1, expression2, … expression_n are the expressions that are not encapsulated within an aggregate function and must be included in the GROUP BY clause.
* aggregate_functionIt can be a function such as SUM, COUNT, MIN, MAX, or AVG functions.