> On 1 Feb 2020, at 23:31, James K. Lowden <jklow...@schemamania.org> wrote: > > Similarly, last I checked, no SQL standard supported LIMIT for SELECT.
Just FYI: The the functionality of LIMIT was added to the SQL standard ISO/IEC 9075 with the 2008 update in form of FETCH FIRST … ROWS ONLY This clause also support some variants like FETCH FIRST 10 PERCENT ONLY and also a WITH TIES modifier. All of that is still there in the current version of the SQL standard (from 2016). I would say LIMIT is widely supported, but it is not standard SQL, maybe common SQL. > > On the positive side, some parts of SQL haven't changed since the Late > Bronze Age. "SELECT *" still means all columns; "FROM" still takes a > table argument, whether a tablename, view, or expression. "WHERE" > operates on values "before" aggregation; "HAVING" on values "after" > aggregation. Any implementation that operates any other way does not > implement standard SQL. > > SQL is hardly unique in this regard. We also refer to "the" C standard > library, to "Posix", and to "the" C or C++ standard. Like SQL, there > are many such and (also like SQL) some parts are unchanged since the > beginning while, just as usefully, some that weren't part of the > first standard haven't changed since they were introduced. When you say “many standards” do you mean the different releases those standards have? IMHO, there is only one SQL standard, namely ISO/IEC 9075. The current and technically only valid version is that of 2016 (even though an extension was added in 2019). -markus _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
