En Sql al momento de declarar SELECT name FROM customer LIMIT 5;

Question

A quien de vosotros le funciona!? Yo puse el código pero no me reconoce LIMIT Y 5 sale con error agradezco ayuda gracias
https://code.sololearn.com/cMK53IP56xnO/?ref=app

Answer 1

Which dbms you're using
Limit works in mysql, sqlite and some others
in sql server and access they're use TOP
Meanwhile oracle use ROWNUM

Answer 2

This is one of those cases where different database engines have different implementation of the same functionality.

See for details:
https://www.w3schools.com/sql/sql_top.asp