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

Lashawna

28 days ago

I got this one. The query looks good to me. Though, I hope the 'animal' table doesn't have any bodybuilding champs, or this could get interesting.

upvoted 0 times

...

Daren

1 months 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

Tresa

2 days ago

So, the correct result would be the name of the second heaviest animal in the table.

upvoted 0 times

...

Deeanna

18 days ago

Yeah, the SQL statement is ordering the animals by weight in descending order and then skipping the first result and returning the next two.

upvoted 0 times

...

Fredric

1 months ago

I think the correct result would be the name of the second heaviest animal in descending order.

upvoted 0 times

...

Minna

2 months 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

Maira

18 days ago

That makes sense. So the query will return the names of the second and third heaviest animals in descending order of weight.

upvoted 0 times

...

Stephanie

26 days ago

Yes, you are correct. The OFFSET 1 will skip the first record, so it will return the third and fourth heaviest animals.

upvoted 0 times

...

Lashunda

2 months 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

...