nerdexam
PostgreSQL_CE

PGCES-02 · Question #92

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;

The correct answer is A. A syntax error will occur.. See the full explanation below for the reasoning.

Question

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;

Options

  • AA syntax error will occur.

How the community answered

(60 responses)
  • A
    100% (60)

Community Discussion

No community discussion yet for this question.

Full PGCES-02 Practice