PostgreSQL Exam PGCES-02 Topic 1 Question 42 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam

Question #: 42
Topic #: 1

The "animal" table consists of the following data: Select the correct result returned by executing the following SQL statement: SELECT name FROM animal ORDER BY weight DESC LIMIT 2 OFFSET 1;

AA syntax error will occur.

Show Suggested Answer

Suggested Answer: A, D

by Van at Mar 31, 2023, 12:23 AM

Limited Time Offer

25%

Off

Get Premium PGCES-02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Daren

2 days ago

Nah, man, this is totally wrong. A syntax error? Come on, this is basic SQL stuff. I bet the person who wrote this question is a llama in disguise.

upvoted 0 times

...

Minna

9 days ago

Hold on, isn't OFFSET 1 going to skip the first record? I think this query will return the third and fourth heaviest animals instead.

upvoted 0 times

...

Lashunda

13 days ago

I'm pretty sure the query is valid. It should return the second and third heaviest animals in the 'animal' table, ordered by weight in descending order.

upvoted 0 times

...