Oracle
1Z0-882 · Question #12
The data from t1 table is: Assuming You want to see this output: Which query achieves the preceding result?
The correct answer is C. SELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1. See the full explanation below for the reasoning.
Question
The data from t1 table is:
Assuming You want to see this output:
Which query achieves the preceding result?
Exhibit
Options
- ASELECT name FROM t1 WHERE name LIKE ,_e%
- BSELECT name FROM t1 WHERE name LIKE,e%.;
- CSELECT name FROM t1 GROUP BY name ORDER by name LIMIT 1,1;
- DSELECT name FROM t1 GROUP BY name HAVING sun ( marks)=176 ORDER BY name;
How the community answered
(22 responses)- A14% (3)
- B9% (2)
- C73% (16)
- D5% (1)
Community Discussion
No community discussion yet for this question.
