Can you name one popular database that does not support the LIMIT operator?

Question

Drupal uses db_query_range()for the reason that not all databases support LIMIT,

can you name a few?

Answer 1

DB2, MSSQL, Oracle, and Informix do not support LIMIT. This is actually not in the SQL standard. (Standard is "FETCH FIRST").

Here is a good source for comparing SQL: http://troels.arvin.dk/db/rdbms/#select-limit

Answer 2

Microsoft SQL Server LIMIT. TOP, . TOP .

Answer 3

ms sql, oracle.

LIMIT ANSI SQL '92, . / / sql

Answer 4

DB2, Oracle MS SQL Server LIMIT.

Google <database name> LIMIT, LIMIT.

Answer 5

, ANSI-92 SQL ROW_NUMBER() , . . SELECT (SQL) .