Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

PostgreSQL Exam PGCES-02 Topic 1 Question 42 Discussion

Actual exam question for PostgreSQL's PGCES-02 exam
Question #: 42
Topic #: 1
[All PGCES-02 Questions]

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;

Show Suggested Answer Hide 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
Minna
7 minutes 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
4 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
...
Franklyn
12 days ago
I'm not sure, but I think the SQL statement will return the name of the heaviest animal.
upvoted 0 times
...
Sherman
13 days ago
I agree with German, the SQL statement will return the name of the second heaviest animal.
upvoted 0 times
...
German
14 days ago
I think the correct result will be the name of the second heaviest animal.
upvoted 0 times
...

Save Cancel