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

Franklyn

1 hours ago

I'm not sure, but I think the SQL statement will return the name of the heaviest animal.

upvoted 0 times

...

Sherman

1 days ago

I agree with German, the SQL statement will return the name of the second heaviest animal.

upvoted 0 times

...

German

2 days ago

I think the correct result will be the name of the second heaviest animal.

upvoted 0 times

...