PostgreSQL_CE
PGCES-02 · Question #49
The table "score" is defined as follows: gid | score -----+------- 1 | 70 1 | 60 2 | 100 3 | 80 3 | 50 The following query was executed. Select the correct result value. SELECT score FROM score…
The correct answer is A. 50. See the full explanation below for the reasoning.
Question
The table "score" is defined as follows:
gid | score -----+------- 1 | 70 1 | 60 2 | 100 3 | 80 3 | 50 The following query was executed. Select the correct result value. SELECT score FROM score ORDER BY gid DESC, score ASC LIMIT 1;
Options
- A50
- B60
- C70
- D80
- E100
How the community answered
(20 responses)- A80% (16)
- B5% (1)
- C10% (2)
- D5% (1)
Community Discussion
No community discussion yet for this question.