SQL : Incorrect options in for the quiz

Question

It seems the incorrect options have been provided for the last question of DISTINCT AND LIMIT quiz

Question is : Use LIMIT to select the 'id' and 'name' columns from 'customers'. Show 12 results starting from the fifth.

_____ id, name From Customers limit _____, ____
options available are : RESULT, SELECT, BY, 4, SHOW, 12.

the blanks should have SELECT, 12, OFFSET 4 as the answer.
It seems options given are incorrect.
Please assist.

Answer 1

Dimple Gurbani
It seems you are correct that the question does not reflect the previous lesson.

Send an email to [e-mail] with your observation.

Maybe they will update the question

Answer 2

SoloProg
I tried your solutions in the Sololearn playground without success.

Do they work external to Sololearn?

Copy of error message

CREATE TABLE
INSERT 0 10
ERROR: LIMIT #,
# syntax is not supported FROM customers LIMIT 4, 6;
^ HINT: Use separate LIMIT and OFFSET clauses.

Answer 3

-- Try it Good Luck

SELECT id, name
FROM customers
LIMIT 4 , 12

Answer 4

SoloProg
Thanks for the feedback & relevant information

Answer 5

-- Copy this code and see the result

SELECT * FROM Customers
LIMIT 4, 12;

https://www.w3schools.com/mysql/trymysql.asp?filename=trysql_select_limit_where

Answer 6

Rik Wittkopp

there are different types and versions of SQL

Write this code in Sololearn

SELECT VERSION();

you will see the result:

PostgreSQL 13.0 on x86_64-pc-linux-musl, compiled by gcc (Alpine 9.3.0) 9.3.0, 64-bit

Answer 7

Write this code in
https://paiza.io/projects/-gHrPj0DKnWlh3HYCf7PeQ?language=mysql

SHOW VARIABLES LIKE 'version';

you will see the result:
version 8.0.28-0ubuntu0.20.04.3

meanwhile write this code in
https://www.w3schools.com

SHOW VARIABLES ;

you will see the result:
rdsdbbin/mysql-5.6.51.R2