6040:
take the powerful RANGE clause as an example. Only Oracle, DB2, Spark/Hive, and Google Big Query fully implement this feature. More recently, vendors have added new extensions to the standard, e.g. array aggregation functions. These are particularly useful in the context of running SQL against a distributed file system (Hadoop, Spark, Google BigQuery) where we have weaker data co-locality guarantees than on a distributed relational database (MPP). Rather than evenly distributing the data across all nodes, SQL engines running queries against a distributed filesystem can achieve data co-locality guarantees by nesting data and thus avoiding potentially expensive joins involving heavy shuffling across the network. User-defined aggregate functions that can be used in window functions are another extremely powerful feature.
2448:
is an approach used to limit and display only a part of the total data of a query in the database. Instead of showing hundreds or thousands of rows at the same time, the server is requested only one page (a limited set of rows, per example only 10 rows), and the user starts navigating by requesting
6039:
The implementation of window function features by vendors of relational databases and SQL engines differs wildly. Most databases support at least some flavour of window functions. However, when we take a closer look it becomes clear that most vendors only implement a subset of the standard. Let's
819:
In the following example, the SQL statement involves a join from the initial Books table to the derived table "Sales". This derived table captures associated book sales information using the ISBN to join to the Books table. As a result, the derived table provides the result set with additional
689:. While joins and other table operations provide computationally superior (i.e. faster) alternatives in many cases (all depending on implementation), the use of subqueries introduces a hierarchy in execution that can be useful or necessary. In the following example, the aggregation function
807:
A derived table is a subquery in a FROM clause. Essentially, the derived table is a subquery that can be selected from or joined to. Derived table functionality allows the user to reference the subquery as a table. The derived table also is referred to as an
1517:
Often it is convenient to indicate a maximum number of rows that are returned. This can be used for testing or to prevent consuming excessive resources if the query returns more information than expected. The approach to do this often varies per vendor.
2449:
the next page, and then the next one, and so on. It is very useful, specially in web systems, where there is no dedicated connection between the client and the server, so the client does not have to wait to read and display all the rows of the server.
1557:
According to
PostgreSQL v.9 documentation, an SQL window function "performs a calculation across a set of table rows that are somehow related to the current row", in a way similar to aggregate functions. The name recalls signal processing
1505:
Although not in standard, most DBMS allows using a select clause without a table by pretending that an imaginary table with one row is used. This is mainly used to perform calculations where a table is not needed.
1438:, except that in the general case, the result may contain duplicate rows. This is also known as a Vertical Partition in some database terms, restricting query output to view only specified fields or columns.
1865:
6029:
the ORDER BY clause is evaluated, ordering the rows and returning VCursor9. This is a cursor and not a table because ANSI defines a cursor as an ordered set of rows (not relational).
397:
The example below demonstrates a query of multiple tables, grouping, and aggregation, by returning a list of books and the number of authors associated with each book.
1478:
will be performed, because of the WHERE clause. This is also known as a
Horizontal Partition, restricting rows output by a query according to specified conditions.
500:
Title
Authors ---------------------- ------- SQL Examples and Guide 4 The Joy of SQL 1 An Introduction to SQL 2 Pitfalls of SQL 1
6486:
5685:
the FROM clause is evaluated, a cross join or
Cartesian product is produced for the first two tables in the FROM clause resulting in a virtual table as Vtable1
6807:
6802:
1857:
This clause currently is supported by CA DATACOM/DB 11, IBM DB2, SAP SQL Anywhere, PostgreSQL, EffiProz, H2, HSQLDB version 2.0, Oracle 12c and
1522:
576:
However, many vendors either do not support this approach, or require certain column-naming conventions for natural joins to work effectively.
309:
clause identifies which column to use to sort the resulting data, and in which direction to sort them (ascending or descending). Without an
5691:
If an outer join is specified, records which were dropped from vTable2 are added into VTable 3, for instance if the above query were:
1502:
will result in every combination of T1 rows with every T2 rows. E.g., if T1 has 3 rows and T2 has 5 rows, then 15 rows will result.
792:
6572:
6567:
5688:
the ON clause is evaluated for vtable1; only records which meet the join condition g.Userid = u.Userid are inserted into Vtable2
1509:
The SELECT clause specifies a list of properties (columns) by name, or the wildcard character (“*”) to mean “all properties”.
5573:
The OVER clause can partition and order the result set. Ordering is used for order-relative functions such as row_number.
1805:
The above code could return more than ten rows, e.g. if there are two people of the same age, it could return eleven rows.
583:
to project data, as in the following example, which returns a list of books that cost more than 100.00 with an additional
6492:
579:
SQL includes operators and functions for calculating values on stored values. SQL allows the use of expressions in the
5896:
the HAVING clause is evaluated for groups for which the HAVING clause is true and inserted into vTable6. For example:
6393:
6354:
1949:
Some DBMSs offer non-standard syntax either instead of or in addition to SQL standard syntax. Below, variants of the
1468:
will result in all the elements of all the rows where the value of column C1 is '1' being shown – in
6497:
1679:
is not unique, each time you run the query it is possible to get different row numbers assigned to any rows where
271:
is often used in conjunction with SQL aggregation functions or to eliminate duplicate rows from a result set. The
80:" as it is responsible for finding the best possible execution plan for the query, within applicable constraints.
1430:
98:
76:" which may vary between executions, database versions and database software. This functionality is called the "
72:
queries specify a result set, but do not specify how to calculate it. The database translates the query into a "
5792:
the WHERE clause is evaluated, in this case only group information for user John Smith would be added to vTable4
1474:
134:
1428:
will result in the elements from the column C1 of all the rows of the table being shown. This is similar to a
6539:
1481:
With more than one table, the result set will be every combination of rows. So if two tables are T1 and T2,
2170:(row numbers are filtered after order by is evaluated. SKIP clause was introduced in a v10.00.xC4 fixpack)
5893:
vTable5 would consist of members returned from vTable4 arranged by the grouping, in this case the GroupName
114:
260:
clause eliminates all rows from the result set where the comparison predicate does not evaluate to True.
2322:
2283:
2188:
1672:
201:
61:
215:
A query includes a list of columns to include in the final result, normally immediately following the
2249:
2080:
4040:
17:
6417:
6507:
780:
65:
6463:
Inside
Microsoft SQL Server 2005: T-SQL Querying by Itzik Ben-Gan, Lubor Kollar, and Dejan Sarka
223:") can be used to specify that the query should return all columns of all the queried tables.
6863:
6715:
256:
clause includes a comparison predicate, which restricts the rows returned by the query. The
189:
statements have no persistent effects on the database. Some non-standard implementations of
6743:
2184:
1988:
681:
Queries can be nested so that the results of one query can be used in another query via a
8:
6786:
6282:
2076:
1539:
773:
682:
212:, and performing the physical operations necessary to produce that result as it chooses.
6321:
336:
column contains a value greater than 100.00. The result is sorted in ascending order by
6622:
6430:
5502:
5487:
2486:
Read all rows but send to display only when the row_number of the rows read is between
1532:
1469:
1435:
784:
227:
is the most complex statement in SQL, with optional keywords and clauses that include:
146:
95:
6502:
6532:
6389:
6350:
6297:
6026:
the DISTINCT clause is evaluated; duplicate rows are removed and returned as Vtable 8
5491:
2135:
91:
795:
allows tree or graph traversals (when represented as relations), and more generally
779:
Since 1999 the SQL standard allows WITH clauses, i.e. named subqueries often called
5581:
The processing of a SELECT statement according to ANSI SQL would be the following:
2551:
rows but send to display only when the row_number of the rows read is greater than
2534:
2192:
2072:
783:(named and designed after the IBM DB2 version 2 implementation; Oracle calls these
182:
42:
6367:
Although the UNIQUE argument is identical to DISTINCT, it is not an ANSI standard.
6383:
6344:
2119:
1559:
209:
77:
53:
49:
4041:
Method with filter (it is more sophisticated but necessary for very big dataset)
2540:
Select all the rows from the beginning of the table to the last row to display (
6736:
6666:
6476:
Horizontal & Vertical
Partitioning, Microsoft SQL Server 2000 Books Online.
4095:
of the first row in the current page), and sort the result in the correct order
2068:
772:
A subquery can use values from the outer query, in which case it is known as a
328:
query returns a list of expensive books. The query retrieves all rows from the
305:
161:
141:
133:
specifies which rows to retrieve. This is approximately the relational algebra
6857:
6781:
6722:
1703:
rows in case of tie conditions, e.g. to return the top-10 youngest persons:
6832:
6750:
6680:
6673:
6652:
6645:
6525:
5789:
all users who did not belong to any groups would be added back into Vtable3
2266:
2167:
2151:
2044:
284:
153:
6512:
6382:; Leon, Mathews (1999). "Eliminating duplicates - SELECT using DISTINCT".
1410:
will result in all the elements of all the rows of the table being shown.
94:
or SQL expressions to be returned by the query. This is approximately the
6757:
6694:
6631:
6379:
6145:
SQL Server 2008 supports the "row constructor" feature, specified in the
4079:
Previous Page: sort the data in the reverse order, select only the first
507:
is the only common column name of the two tables and that a column named
252:
129:
105:
820:
columns (the number of items sold and the company that sold the books):
6764:
6701:
6687:
6659:
6638:
6388:. New Delhi: Tata McGraw-Hill Education (published 2008). p. 143.
6310:
Omitting FROM clause is not standard, but allowed by most major DBMSes.
2048:
1699:
window function acts like ROW_NUMBER, but may return more or less than
243:
233:
205:
121:
73:
38:
27:
SQL statement that returns a result set of rows from one or more tables
2473:= Number of the row - 1 where the page starts = (page_number-1) * rows
1817:
results limits can be specified as in the following example using the
267:
clause projects rows having common values into a smaller set of rows.
2060:
1858:
788:
6406:
the keyword DISTINCT eliminates the duplicates from the result set.
6708:
6612:
6607:
6602:
6597:
6592:
6587:
6582:
6146:
5498:
2434:(new rows are filtered after comparing with key column of table T)
2233:
2200:
1814:
1547:
1525:
796:
288:
clause includes a predicate used to filter rows resulting from the
5545:
calculates the sum of the populations of all rows having the same
109:
optionally provides an alias for each column or expression in the
6842:
6837:
6827:
6822:
6817:
6812:
2431:
2377:
2064:
2040:
2032:
515:
table, one could re-write the query above in the following form:
2535:
Other simple method (a little more efficient than read all rows)
313:
clause, the order of rows returned by an SQL query is undefined.
237:
clause, which indicates the table(s) to retrieve data from. The
48:
A SELECT statement retrieves zero or more rows from one or more
6577:
6562:
2196:
2056:
2052:
6418:
PostgreSQL 9.1.24 Documentation - Chapter 3. Advanced
Features
6349:. SAS Institute (published 2013). 10 July 2013. p. 248.
2036:
587:
column containing a sales tax figure calculated at 6% of the
200:
Queries allow the user to describe desired data, leaving the
4100:
Read and send to display all the rows read from the database
3024:
Read and send to display all the rows read from the database
1581:
on the returned rows, e.g. to return no more than ten rows:
6034:
685:
or aggregation function. A nested query is also known as a
2043:(also supports the standard version, since version 10.6),
6548:
2477:
1687:
is unique, each row will always get a unique row number.
177:
is the most common operation in SQL, called "the query".
31:
6838:
SQL Routines and Types for the Java
Programming Language
157:
selects among the groups defined by the GROUP BY clause.
1991:(This also works on Microsoft SQL Server 6.5 while the
6517:
6326:. SQL Server 2005 Books Online. Microsoft. 2007-09-15
6023:
the SELECT list is evaluated and returned as Vtable 7
5795:
the GROUP BY is evaluated; if the above query were:
4064:rows, depending on the type of database, where the
247:
subclauses to specify the rules for joining tables.
2269:(also supports the standard, since version 9.0.1)
6313:
2051:(also supports the standard, since version 8.4),
296:clause, aggregation functions can be used in the
6855:
83:The SELECT statement has many optional clauses:
6048:Method to generate data based on the union all
1569:
5556:clause which modifies the aggregate. Syntax:
2452:
292:clause. Because it acts on the results of the
6533:
6428:
497:Example output might resemble the following:
3017:rows starting from the next row to display (
1562:. A window function call always contains an
1367:
1301:
1240:
1216:
1155:
1132:
1083:
1051:
1002:
693:receives as input the result of a subquery:
348:table should be included in the result set.
6043:
125:specifies from which table to get the data.
6540:
6526:
6487:Windowed Tables and Window function in SQL
5505:applied to a partition of the result set.
3007:
145:groups rows sharing a property so that an
6280:
1887:clauses are all required for this usage.
1690:
193:can have persistent effects, such as the
165:specifies how to order the returned rows.
6422:
6378:
6035:Window function support by RDBMS vendors
5576:
4057:rows, depending on the type of database
1953:query for different DBMSes are listed:
1512:
14:
6856:
2478:Simplest method (but very inefficient)
1944:
1528:, result sets may be limited by using
6521:
5569: :: = OVER ( )
5481:
1864:Microsoft SQL Server 2008 and higher
1808:
113:list. This is the relational algebra
4076:of the last row in the current page)
5552:Partitions are specified using the
1871:, but it is considered part of the
197:syntax provided in some databases.
24:
6833:Information and Definition Schemas
6346:SAS 9.4 SQL Procedure User's Guide
4053:First Page: select only the first
2440:
344:indicates that all columns of the
320:keyword eliminates duplicate data.
25:
6875:
6480:
6295:
6283:"Transact-SQL Syntax Conventions"
4060:Next Page: select only the first
2483:Select all rows from the database
202:database management system (DBMS)
6431:"9.19.10. The TOP SELECT Option"
802:
181:retrieves data from one or more
6457:
1482:
1442:
1441:With the same table, the query
1414:
1413:With the same table, the query
1396:
1336:
1270:
1185:
1113:
1032:
6448:
6411:
6372:
6337:
6304:
6289:
6274:
13:
1:
6323:SQL Server Language Reference
6267:
2252:(skips 20, delivers next 10)
676:
275:clause is applied before the
149:can be applied to each group.
2467:= Number of the current page
1570:ROW_NUMBER() window function
1366:
1332:
1300:
1239:
1215:
1154:
1131:
1082:
1050:
1001:
791:by referring to themselves;
503:Under the precondition that
241:clause can include optional
7:
6823:Management of External Data
2453:Data in Pagination approach
987:
983:
324:The following example of a
185:, or expressions. Standard
169:
64:(DML) command. As SQL is a
10:
6880:
6843:XML-Related Specifications
6470:
6320:"Transact-SQL Reference".
5549:value as the current row.
2461:= Number of rows in a page
340:. The asterisk (*) in the
62:data manipulation language
60:is the most commonly used
41:of rows, from one or more
6818:Persistent Stored Modules
6795:
6774:
6621:
6555:
6385:SQL: A Complete Reference
6281:Microsoft (23 May 2023).
6828:Object Language Bindings
6508:PostgreSQL SELECT syntax
6151:
6050:
6044:Generating data in T-SQL
5897:
5796:
5692:
5586:
5558:
5510:
5340:
5241:
5166:
5161:Sybase, SQL Server 2000
5038:
4951:
4888:
4772:
4697:
4646:
4528:
4453:
4402:
4265:
4181:
4121:
3893:
3735:
3616:
3476:
3348:
3277:
3205:
3131:
3039:
2917:
2912:Sybase, SQL Server 2000
2843:
2778:
2716:
2652:
2569:
2496:
2384:
2330:
2290:
2207:
2087:
2000:
1959:
1889:
1823:
1705:
1583:
822:
781:common table expressions
695:
593:
517:
399:
350:
56:. In most applications,
6547:
6454:Ing. Ă“scar Bonilla, MBA
5486:Some databases provide
3008:Method with positioning
2163:* FROM T order by c, d
1542:to the SELECT-statement
793:the resulting mechanism
219:keyword. An asterisk ("
66:declarative programming
6498:Firebird SELECT syntax
1993:Select top 10 * from T
1691:RANK() window function
5577:Query evaluation ANSI
5497:A window function in
2549:{begin_base_0 + rows}
2542:{begin_base_0 + rows}
2492:{begin_base_0 + rows}
1392:Given a table T, the
6813:Call-Level Interface
6513:SQLite SELECT syntax
6493:Oracle SELECT syntax
2325:(since version 2.1)
2147:* FROM T order by a
1513:Limiting result rows
787:). CTEs can also be
90:list is the list of
37:statement returns a
6787:Relational database
6503:MySQL SELECT syntax
6435:docs.openlinksw.com
6429:OpenLink Software.
6298:"SQL SELECT Syntax"
3343:Sybase, ASE 16 SP2
2838:Sybase, ASE 16 SP2
2077:Snowflake Computing
1945:Non-standard syntax
1540:SQL window function
814:select in from list
774:correlated subquery
683:relational operator
511:only exists in the
332:table in which the
5503:aggregate function
5488:specialised syntax
5482:Hierarchical query
4091:(the value of the
4072:(the value of the
4050:rows with filter:
3019:{begin_base_0 + 1}
2488:{begin_base_0 + 1}
2260:TOP 10 START AT 20
1809:FETCH FIRST clause
1683:is the same. When
1671:ROW_NUMBER can be
1577:may be used for a
1470:relational algebra
1436:relational algebra
785:subquery factoring
147:aggregate function
96:relational algebra
6851:
6850:
6796:ISO/IEC SQL parts
5492:hierarchical data
5479:
5478:
4046:Select only then
4035:
4034:
3002:
3001:
2438:
2437:
2250:OpenLink Virtuoso
2081:OpenLink Virtuoso
1673:non-deterministic
1575:ROW_NUMBER() OVER
1390:
1389:
1386:
1385:
1328:
1327:
1267:
1266:
1235:
1234:
1182:
1181:
1150:
1149:
1110:
1109:
1078:
1077:
1029:
1028:
300:clause predicate.
16:(Redirected from
6871:
6767:
6760:
6753:
6746:
6739:
6732:
6725:
6718:
6711:
6704:
6697:
6690:
6683:
6676:
6669:
6662:
6655:
6648:
6641:
6634:
6542:
6535:
6528:
6519:
6518:
6489:, Stefan DeĂźloch
6464:
6461:
6455:
6452:
6446:
6445:
6443:
6441:
6426:
6420:
6415:
6409:
6408:
6403:
6402:
6376:
6370:
6369:
6364:
6363:
6341:
6335:
6334:
6332:
6331:
6317:
6311:
6308:
6302:
6301:
6293:
6287:
6286:
6278:
6263:
6260:
6257:
6254:
6251:
6248:
6245:
6242:
6239:
6236:
6233:
6230:
6227:
6224:
6221:
6218:
6215:
6212:
6209:
6206:
6203:
6200:
6197:
6194:
6191:
6188:
6185:
6182:
6179:
6176:
6173:
6170:
6167:
6164:
6161:
6158:
6155:
6141:
6138:
6135:
6132:
6129:
6126:
6123:
6120:
6117:
6114:
6111:
6108:
6105:
6102:
6099:
6096:
6093:
6090:
6087:
6084:
6081:
6078:
6075:
6072:
6069:
6066:
6063:
6060:
6057:
6054:
6018:
6015:
6012:
6009:
6006:
6003:
6000:
5997:
5994:
5991:
5988:
5985:
5982:
5979:
5976:
5973:
5970:
5967:
5964:
5961:
5958:
5955:
5952:
5949:
5946:
5943:
5940:
5937:
5934:
5931:
5928:
5925:
5922:
5919:
5916:
5913:
5910:
5907:
5904:
5901:
5890:
5887:
5884:
5881:
5878:
5875:
5872:
5869:
5866:
5863:
5860:
5857:
5854:
5851:
5848:
5845:
5842:
5839:
5836:
5833:
5830:
5827:
5824:
5821:
5818:
5815:
5812:
5809:
5806:
5803:
5800:
5786:
5783:
5780:
5777:
5774:
5771:
5768:
5765:
5762:
5759:
5756:
5753:
5750:
5747:
5744:
5741:
5738:
5735:
5732:
5729:
5726:
5723:
5720:
5717:
5714:
5711:
5708:
5705:
5702:
5699:
5696:
5680:
5677:
5674:
5671:
5668:
5665:
5662:
5659:
5656:
5653:
5650:
5647:
5644:
5641:
5638:
5635:
5632:
5629:
5626:
5623:
5620:
5617:
5614:
5611:
5608:
5605:
5602:
5599:
5596:
5593:
5590:
5568:
5565:
5562:
5541:
5538:
5535:
5532:
5529:
5526:
5523:
5520:
5517:
5514:
5470:
5467:
5464:
5461:
5458:
5455:
5452:
5449:
5446:
5443:
5440:
5437:
5434:
5431:
5428:
5425:
5422:
5419:
5416:
5413:
5410:
5407:
5404:
5401:
5398:
5395:
5392:
5389:
5386:
5383:
5380:
5377:
5374:
5371:
5368:
5365:
5362:
5359:
5356:
5353:
5350:
5347:
5344:
5335:
5332:
5329:
5326:
5323:
5320:
5317:
5314:
5311:
5308:
5305:
5302:
5299:
5296:
5293:
5290:
5287:
5284:
5281:
5278:
5275:
5272:
5269:
5266:
5263:
5260:
5257:
5254:
5251:
5248:
5245:
5236:
5233:
5230:
5227:
5224:
5221:
5218:
5215:
5212:
5209:
5206:
5203:
5200:
5197:
5194:
5191:
5188:
5185:
5182:
5179:
5176:
5173:
5170:
5156:
5153:
5150:
5147:
5144:
5141:
5138:
5135:
5132:
5129:
5126:
5123:
5120:
5117:
5114:
5111:
5108:
5105:
5102:
5099:
5096:
5093:
5090:
5087:
5084:
5081:
5078:
5075:
5072:
5069:
5066:
5063:
5060:
5057:
5054:
5051:
5048:
5045:
5042:
5033:
5030:
5027:
5024:
5021:
5018:
5015:
5012:
5009:
5006:
5003:
5000:
4997:
4994:
4991:
4988:
4985:
4982:
4979:
4976:
4973:
4970:
4967:
4964:
4961:
4958:
4955:
4946:
4943:
4940:
4937:
4934:
4931:
4928:
4925:
4922:
4919:
4916:
4913:
4910:
4907:
4904:
4901:
4898:
4895:
4892:
4883:SQL Server 2005
4878:
4875:
4872:
4869:
4866:
4863:
4860:
4857:
4854:
4851:
4848:
4845:
4842:
4839:
4836:
4833:
4830:
4827:
4824:
4821:
4818:
4815:
4812:
4809:
4806:
4803:
4800:
4797:
4794:
4791:
4788:
4785:
4782:
4779:
4776:
4767:
4764:
4761:
4758:
4755:
4752:
4749:
4746:
4743:
4740:
4737:
4734:
4731:
4728:
4725:
4722:
4719:
4716:
4713:
4710:
4707:
4704:
4701:
4692:
4689:
4686:
4683:
4680:
4677:
4674:
4671:
4668:
4665:
4662:
4659:
4656:
4653:
4650:
4634:
4631:
4628:
4625:
4622:
4619:
4616:
4613:
4610:
4607:
4604:
4601:
4598:
4595:
4592:
4589:
4586:
4583:
4580:
4577:
4574:
4571:
4568:
4565:
4562:
4559:
4556:
4553:
4550:
4547:
4544:
4541:
4538:
4535:
4532:
4523:
4520:
4517:
4514:
4511:
4508:
4505:
4502:
4499:
4496:
4493:
4490:
4487:
4484:
4481:
4478:
4475:
4472:
4469:
4466:
4463:
4460:
4457:
4448:
4445:
4442:
4439:
4436:
4433:
4430:
4427:
4424:
4421:
4418:
4415:
4412:
4409:
4406:
4380:
4377:
4374:
4371:
4368:
4365:
4362:
4359:
4356:
4353:
4350:
4347:
4344:
4341:
4338:
4335:
4332:
4329:
4326:
4323:
4320:
4317:
4314:
4311:
4308:
4305:
4302:
4299:
4296:
4293:
4290:
4287:
4284:
4281:
4278:
4275:
4272:
4269:
4260:
4257:
4254:
4251:
4248:
4245:
4242:
4239:
4236:
4233:
4230:
4227:
4224:
4221:
4218:
4215:
4212:
4209:
4206:
4203:
4200:
4197:
4194:
4191:
4188:
4185:
4176:
4173:
4170:
4167:
4164:
4161:
4158:
4155:
4152:
4149:
4146:
4143:
4140:
4137:
4134:
4131:
4128:
4125:
4104:
4103:
4094:
4090:
4086:
4083:rows, where the
4082:
4075:
4071:
4068:is greater than
4067:
4063:
4056:
4049:
4026:
4023:
4020:
4017:
4014:
4011:
4008:
4005:
4002:
3999:
3996:
3993:
3990:
3987:
3984:
3981:
3978:
3975:
3972:
3969:
3966:
3963:
3960:
3957:
3954:
3951:
3948:
3945:
3942:
3939:
3936:
3933:
3930:
3927:
3924:
3921:
3918:
3915:
3912:
3909:
3906:
3903:
3900:
3897:
3888:SQL Server 2000
3883:
3880:
3877:
3874:
3871:
3868:
3865:
3862:
3859:
3856:
3853:
3850:
3847:
3844:
3841:
3838:
3835:
3832:
3829:
3826:
3823:
3820:
3817:
3814:
3811:
3808:
3805:
3802:
3799:
3796:
3793:
3790:
3787:
3784:
3781:
3778:
3775:
3772:
3769:
3766:
3763:
3760:
3757:
3754:
3751:
3748:
3745:
3742:
3739:
3730:SQL Server 2005
3722:
3719:
3716:
3713:
3710:
3707:
3704:
3701:
3698:
3695:
3692:
3689:
3686:
3683:
3680:
3677:
3674:
3671:
3668:
3665:
3662:
3659:
3656:
3653:
3650:
3647:
3644:
3641:
3638:
3635:
3632:
3629:
3626:
3623:
3620:
3606:
3603:
3600:
3597:
3594:
3591:
3588:
3585:
3582:
3579:
3576:
3573:
3570:
3567:
3564:
3561:
3558:
3555:
3552:
3549:
3546:
3543:
3540:
3537:
3534:
3531:
3528:
3525:
3522:
3519:
3516:
3513:
3510:
3507:
3504:
3501:
3498:
3495:
3492:
3489:
3486:
3483:
3480:
3466:
3463:
3460:
3457:
3454:
3451:
3448:
3445:
3442:
3439:
3436:
3433:
3430:
3427:
3424:
3421:
3418:
3415:
3412:
3409:
3406:
3403:
3400:
3397:
3394:
3391:
3388:
3385:
3382:
3379:
3376:
3373:
3370:
3367:
3364:
3361:
3358:
3355:
3352:
3338:
3335:
3332:
3329:
3326:
3323:
3320:
3317:
3314:
3311:
3308:
3305:
3302:
3299:
3296:
3293:
3290:
3287:
3284:
3281:
3263:
3260:
3257:
3254:
3251:
3248:
3245:
3242:
3239:
3236:
3233:
3230:
3227:
3224:
3221:
3218:
3215:
3212:
3209:
3189:
3186:
3183:
3180:
3177:
3174:
3171:
3168:
3165:
3162:
3159:
3156:
3153:
3150:
3147:
3144:
3141:
3138:
3135:
3109:
3106:
3103:
3100:
3097:
3094:
3091:
3088:
3085:
3082:
3079:
3076:
3073:
3070:
3067:
3064:
3061:
3058:
3055:
3052:
3049:
3046:
3043:
3028:
3027:
3020:
3016:
2993:
2990:
2987:
2984:
2981:
2978:
2975:
2972:
2969:
2966:
2963:
2960:
2957:
2954:
2951:
2948:
2945:
2942:
2939:
2936:
2933:
2930:
2927:
2924:
2921:
2907:
2904:
2901:
2898:
2895:
2892:
2889:
2886:
2883:
2880:
2877:
2874:
2871:
2868:
2865:
2862:
2859:
2856:
2853:
2850:
2847:
2833:
2830:
2827:
2824:
2821:
2818:
2815:
2812:
2809:
2806:
2803:
2800:
2797:
2794:
2791:
2788:
2785:
2782:
2773:SQL Server 2005
2768:
2765:
2762:
2759:
2756:
2753:
2750:
2747:
2744:
2741:
2738:
2735:
2732:
2729:
2726:
2723:
2720:
2704:
2701:
2698:
2695:
2692:
2689:
2686:
2683:
2680:
2677:
2674:
2671:
2668:
2665:
2662:
2659:
2656:
2630:
2627:
2624:
2621:
2618:
2615:
2612:
2609:
2606:
2603:
2600:
2597:
2594:
2591:
2588:
2585:
2582:
2579:
2576:
2573:
2558:
2557:
2554:
2550:
2543:
2530:
2527:
2524:
2521:
2518:
2515:
2512:
2509:
2506:
2503:
2500:
2493:
2489:
2472:
2466:
2460:
2426:
2425:
2422:
2419:
2416:
2413:
2410:
2407:
2404:
2401:
2397:
2394:
2391:
2388:
2372:
2371:
2368:
2365:
2362:
2359:
2356:
2353:
2350:
2347:
2343:
2340:
2337:
2334:
2317:
2316:
2313:
2310:
2307:
2303:
2300:
2297:
2294:
2280:
2277:FIRST 10 SKIP 20
2267:SAP SQL Anywhere
2263:
2246:
2228:
2227:
2224:
2220:
2217:
2214:
2211:
2181:
2164:
2161:SKIP 20 FIRST 10
2148:
2132:
2114:
2113:
2110:
2107:
2104:
2100:
2097:
2094:
2091:
2073:Couchbase Server
2045:SAP SQL Anywhere
2027:
2026:
2023:
2020:
2017:
2013:
2010:
2007:
2004:
1983:
1980:
1977:
1974:
1971:
1970:
1967:
1964:
1956:
1955:
1940:
1939:
1936:
1933:
1930:
1927:
1924:
1921:
1918:
1915:
1912:
1909:
1906:
1902:
1899:
1896:
1893:
1886:
1882:
1878:
1874:
1869:
1853:
1852:
1849:
1846:
1843:
1840:
1836:
1833:
1830:
1827:
1820:
1801:
1798:
1795:
1792:
1789:
1786:
1783:
1780:
1777:
1774:
1771:
1768:
1765:
1762:
1759:
1758:
1755:
1752:
1749:
1746:
1743:
1740:
1737:
1734:
1731:
1728:
1725:
1721:
1718:
1715:
1712:
1709:
1698:
1667:
1664:
1661:
1658:
1655:
1652:
1649:
1646:
1643:
1640:
1637:
1636:
1633:
1630:
1627:
1624:
1621:
1618:
1615:
1612:
1609:
1606:
1603:
1599:
1596:
1593:
1590:
1587:
1576:
1560:window functions
1553:
1501:
1500:
1497:
1494:
1491:
1488:
1485:
1467:
1466:
1463:
1460:
1457:
1454:
1451:
1448:
1445:
1427:
1426:
1423:
1420:
1417:
1409:
1408:
1405:
1402:
1399:
1368:
1364:
1363:
1360:
1357:
1354:
1351:
1348:
1345:
1342:
1339:
1302:
1298:
1297:
1294:
1291:
1288:
1285:
1282:
1279:
1276:
1273:
1241:
1217:
1213:
1212:
1209:
1206:
1203:
1200:
1197:
1194:
1191:
1188:
1156:
1133:
1129:
1128:
1125:
1122:
1119:
1116:
1084:
1052:
1048:
1047:
1044:
1041:
1038:
1035:
1003:
988:
979:
976:
973:
970:
967:
964:
961:
958:
955:
952:
949:
946:
943:
940:
937:
934:
931:
928:
925:
922:
919:
916:
913:
910:
907:
904:
901:
898:
895:
892:
889:
886:
883:
880:
877:
874:
871:
868:
865:
862:
859:
856:
853:
850:
847:
844:
841:
838:
835:
832:
829:
826:
768:
765:
762:
759:
756:
753:
750:
747:
744:
741:
738:
735:
732:
729:
726:
723:
720:
717:
714:
711:
708:
705:
702:
699:
692:
672:
669:
666:
663:
660:
657:
654:
651:
648:
645:
642:
639:
636:
633:
630:
627:
624:
621:
618:
615:
612:
609:
606:
603:
600:
597:
572:
569:
566:
563:
560:
557:
554:
551:
548:
545:
542:
539:
536:
533:
530:
527:
524:
521:
493:
490:
487:
484:
481:
478:
475:
472:
469:
466:
463:
460:
457:
454:
451:
448:
445:
442:
439:
436:
433:
430:
427:
424:
421:
418:
415:
412:
409:
406:
403:
393:
390:
387:
384:
381:
378:
375:
372:
369:
366:
363:
360:
357:
354:
327:
319:
312:
308:
299:
295:
291:
287:
278:
274:
270:
266:
259:
255:
246:
240:
236:
226:
222:
218:
196:
192:
188:
180:
176:
164:
156:
144:
132:
124:
112:
108:
89:
71:
59:
21:
6879:
6878:
6874:
6873:
6872:
6870:
6869:
6868:
6854:
6853:
6852:
6847:
6791:
6770:
6763:
6756:
6749:
6742:
6735:
6728:
6721:
6714:
6707:
6700:
6693:
6686:
6679:
6672:
6665:
6658:
6651:
6644:
6637:
6630:
6617:
6551:
6546:
6483:
6473:
6468:
6467:
6462:
6458:
6453:
6449:
6439:
6437:
6427:
6423:
6416:
6412:
6400:
6398:
6396:
6377:
6373:
6361:
6359:
6357:
6343:
6342:
6338:
6329:
6327:
6319:
6318:
6314:
6309:
6305:
6294:
6290:
6279:
6275:
6270:
6265:
6264:
6261:
6258:
6255:
6252:
6249:
6246:
6243:
6240:
6237:
6234:
6231:
6228:
6225:
6222:
6219:
6216:
6213:
6210:
6207:
6204:
6201:
6198:
6195:
6192:
6189:
6186:
6183:
6180:
6177:
6174:
6171:
6168:
6165:
6162:
6159:
6156:
6153:
6143:
6142:
6139:
6136:
6133:
6130:
6127:
6124:
6121:
6118:
6115:
6112:
6109:
6106:
6103:
6100:
6097:
6094:
6091:
6088:
6085:
6082:
6079:
6076:
6073:
6070:
6067:
6064:
6061:
6058:
6055:
6052:
6046:
6037:
6032:
6020:
6019:
6016:
6013:
6010:
6007:
6004:
6001:
5998:
5995:
5992:
5989:
5986:
5983:
5980:
5977:
5974:
5971:
5968:
5965:
5962:
5959:
5956:
5953:
5950:
5947:
5944:
5941:
5938:
5936:NumberOfMembers
5935:
5932:
5929:
5926:
5923:
5920:
5917:
5914:
5911:
5908:
5905:
5902:
5899:
5892:
5891:
5888:
5885:
5882:
5879:
5876:
5873:
5870:
5867:
5864:
5861:
5858:
5855:
5852:
5849:
5846:
5843:
5840:
5837:
5835:NumberOfMembers
5834:
5831:
5828:
5825:
5822:
5819:
5816:
5813:
5810:
5807:
5804:
5801:
5798:
5788:
5787:
5784:
5781:
5778:
5775:
5772:
5769:
5767:'Smith'
5766:
5763:
5760:
5757:
5754:
5751:
5748:
5745:
5742:
5739:
5736:
5733:
5730:
5727:
5724:
5721:
5718:
5715:
5712:
5709:
5706:
5703:
5700:
5697:
5694:
5682:
5681:
5678:
5675:
5672:
5669:
5666:
5663:
5661:'Smith'
5660:
5657:
5654:
5651:
5648:
5645:
5642:
5639:
5636:
5633:
5630:
5627:
5624:
5621:
5618:
5615:
5612:
5609:
5606:
5603:
5600:
5597:
5594:
5591:
5588:
5579:
5571:
5570:
5566:
5563:
5560:
5543:
5542:
5539:
5536:
5533:
5530:
5527:
5524:
5521:
5518:
5515:
5512:
5484:
5472:
5471:
5468:
5465:
5462:
5459:
5456:
5453:
5450:
5447:
5444:
5441:
5438:
5435:
5432:
5429:
5426:
5423:
5420:
5417:
5414:
5411:
5408:
5405:
5402:
5399:
5396:
5393:
5390:
5387:
5384:
5381:
5378:
5375:
5372:
5369:
5366:
5363:
5360:
5357:
5354:
5351:
5348:
5345:
5342:
5337:
5336:
5333:
5330:
5327:
5324:
5321:
5318:
5315:
5312:
5309:
5306:
5303:
5300:
5297:
5294:
5291:
5288:
5285:
5282:
5279:
5276:
5273:
5270:
5267:
5264:
5261:
5258:
5255:
5252:
5249:
5246:
5243:
5238:
5237:
5234:
5231:
5228:
5225:
5222:
5219:
5216:
5213:
5210:
5207:
5204:
5201:
5198:
5195:
5192:
5189:
5186:
5183:
5180:
5177:
5174:
5171:
5168:
5158:
5157:
5154:
5151:
5148:
5145:
5142:
5139:
5136:
5133:
5130:
5127:
5124:
5121:
5118:
5115:
5112:
5109:
5106:
5103:
5100:
5097:
5094:
5091:
5088:
5085:
5082:
5079:
5076:
5073:
5070:
5067:
5064:
5061:
5058:
5055:
5052:
5049:
5046:
5043:
5040:
5035:
5034:
5031:
5028:
5025:
5022:
5019:
5016:
5013:
5010:
5007:
5004:
5001:
4998:
4995:
4992:
4989:
4986:
4983:
4980:
4977:
4974:
4971:
4968:
4965:
4962:
4959:
4956:
4953:
4948:
4947:
4944:
4941:
4938:
4935:
4932:
4929:
4926:
4923:
4920:
4917:
4914:
4911:
4908:
4905:
4902:
4899:
4896:
4893:
4890:
4880:
4879:
4876:
4873:
4870:
4867:
4864:
4861:
4858:
4855:
4852:
4849:
4846:
4843:
4840:
4837:
4834:
4831:
4828:
4825:
4822:
4819:
4816:
4813:
4810:
4807:
4804:
4801:
4798:
4795:
4792:
4789:
4786:
4783:
4780:
4777:
4774:
4769:
4768:
4765:
4762:
4759:
4756:
4753:
4750:
4747:
4744:
4741:
4738:
4735:
4732:
4729:
4726:
4723:
4720:
4717:
4714:
4711:
4708:
4705:
4702:
4699:
4694:
4693:
4690:
4687:
4684:
4681:
4678:
4675:
4672:
4669:
4666:
4663:
4660:
4657:
4654:
4651:
4648:
4640:
4636:
4635:
4632:
4629:
4626:
4623:
4620:
4617:
4614:
4611:
4608:
4605:
4602:
4599:
4596:
4593:
4590:
4587:
4584:
4581:
4578:
4575:
4572:
4569:
4566:
4563:
4560:
4557:
4554:
4551:
4548:
4545:
4542:
4539:
4536:
4533:
4530:
4525:
4524:
4521:
4518:
4515:
4512:
4509:
4506:
4503:
4500:
4497:
4494:
4491:
4488:
4485:
4482:
4479:
4476:
4473:
4470:
4467:
4464:
4461:
4458:
4455:
4450:
4449:
4446:
4443:
4440:
4437:
4434:
4431:
4428:
4425:
4422:
4419:
4416:
4413:
4410:
4407:
4404:
4396:
4394:
4392:
4390:
4389:SQL Server 2012
4388:
4386:
4382:
4381:
4378:
4375:
4372:
4369:
4366:
4363:
4360:
4357:
4354:
4351:
4348:
4345:
4342:
4339:
4336:
4333:
4330:
4327:
4324:
4321:
4318:
4315:
4312:
4309:
4306:
4303:
4300:
4297:
4294:
4291:
4288:
4285:
4282:
4279:
4276:
4273:
4270:
4267:
4262:
4261:
4258:
4255:
4252:
4249:
4246:
4243:
4240:
4237:
4234:
4231:
4228:
4225:
4222:
4219:
4216:
4213:
4210:
4207:
4204:
4201:
4198:
4195:
4192:
4189:
4186:
4183:
4178:
4177:
4174:
4171:
4168:
4165:
4162:
4159:
4156:
4153:
4150:
4147:
4144:
4141:
4138:
4135:
4132:
4129:
4126:
4123:
4092:
4088:
4084:
4080:
4073:
4069:
4065:
4061:
4054:
4047:
4043:
4037:
4028:
4027:
4024:
4021:
4018:
4015:
4012:
4009:
4006:
4003:
4000:
3997:
3994:
3991:
3988:
3985:
3982:
3979:
3976:
3973:
3970:
3967:
3964:
3961:
3958:
3955:
3952:
3949:
3946:
3943:
3940:
3937:
3934:
3931:
3928:
3925:
3922:
3919:
3916:
3913:
3910:
3907:
3904:
3901:
3898:
3895:
3885:
3884:
3881:
3878:
3875:
3872:
3869:
3866:
3863:
3860:
3857:
3854:
3851:
3848:
3845:
3842:
3839:
3836:
3833:
3830:
3827:
3824:
3821:
3818:
3815:
3812:
3809:
3806:
3803:
3800:
3797:
3794:
3791:
3788:
3785:
3782:
3779:
3776:
3773:
3770:
3767:
3764:
3761:
3758:
3755:
3752:
3749:
3746:
3743:
3740:
3737:
3726:
3724:
3723:
3720:
3717:
3714:
3711:
3708:
3705:
3702:
3699:
3696:
3693:
3690:
3687:
3684:
3681:
3678:
3675:
3672:
3669:
3666:
3663:
3660:
3657:
3654:
3651:
3648:
3645:
3642:
3639:
3636:
3633:
3630:
3627:
3624:
3621:
3618:
3611:Sybase 12.5.2:
3608:
3607:
3604:
3601:
3598:
3595:
3592:
3589:
3586:
3583:
3580:
3577:
3574:
3571:
3568:
3565:
3562:
3559:
3556:
3553:
3550:
3547:
3544:
3541:
3538:
3535:
3532:
3529:
3526:
3523:
3520:
3517:
3514:
3511:
3508:
3505:
3502:
3499:
3496:
3493:
3490:
3487:
3484:
3481:
3478:
3471:Sybase 12.5.3:
3468:
3467:
3464:
3461:
3458:
3455:
3452:
3449:
3446:
3443:
3440:
3437:
3434:
3431:
3428:
3425:
3422:
3419:
3416:
3413:
3410:
3407:
3404:
3401:
3398:
3395:
3392:
3389:
3386:
3383:
3380:
3377:
3374:
3371:
3368:
3365:
3362:
3359:
3356:
3353:
3350:
3340:
3339:
3336:
3333:
3330:
3327:
3324:
3321:
3318:
3315:
3312:
3309:
3306:
3303:
3300:
3297:
3294:
3291:
3288:
3285:
3282:
3279:
3271:
3269:
3265:
3264:
3261:
3258:
3255:
3252:
3249:
3246:
3243:
3240:
3237:
3234:
3231:
3228:
3225:
3222:
3219:
3216:
3213:
3210:
3207:
3199:
3197:
3195:
3191:
3190:
3187:
3184:
3181:
3178:
3175:
3172:
3169:
3166:
3163:
3160:
3157:
3154:
3151:
3148:
3145:
3142:
3139:
3136:
3133:
3125:
3123:
3121:
3119:
3118:SQL Server 2012
3117:
3115:
3111:
3110:
3107:
3104:
3101:
3098:
3095:
3092:
3089:
3086:
3083:
3080:
3077:
3074:
3071:
3068:
3065:
3062:
3059:
3056:
3053:
3050:
3047:
3044:
3041:
3018:
3014:
3010:
3004:
2995:
2994:
2991:
2988:
2985:
2982:
2979:
2976:
2973:
2970:
2967:
2964:
2961:
2958:
2955:
2952:
2949:
2946:
2943:
2940:
2937:
2934:
2931:
2928:
2925:
2922:
2919:
2909:
2908:
2905:
2902:
2899:
2896:
2893:
2890:
2887:
2884:
2881:
2878:
2875:
2872:
2869:
2866:
2863:
2860:
2857:
2854:
2851:
2848:
2845:
2835:
2834:
2831:
2828:
2825:
2822:
2819:
2816:
2813:
2810:
2807:
2804:
2801:
2798:
2795:
2792:
2789:
2786:
2783:
2780:
2770:
2769:
2766:
2763:
2760:
2757:
2754:
2751:
2748:
2745:
2742:
2739:
2736:
2733:
2730:
2727:
2724:
2721:
2718:
2710:
2706:
2705:
2702:
2699:
2696:
2693:
2690:
2687:
2684:
2681:
2678:
2675:
2672:
2669:
2666:
2663:
2660:
2657:
2654:
2646:
2644:
2642:
2640:
2639:SQL Server 2012
2638:
2636:
2632:
2631:
2628:
2625:
2622:
2619:
2616:
2613:
2610:
2607:
2604:
2601:
2598:
2595:
2592:
2589:
2586:
2583:
2580:
2577:
2574:
2571:
2552:
2548:
2541:
2537:
2532:
2531:
2528:
2525:
2522:
2519:
2516:
2513:
2510:
2507:
2504:
2501:
2498:
2491:
2487:
2480:
2470:
2464:
2458:
2455:
2446:Rows Pagination
2443:
2441:Rows Pagination
2428:
2427:
2423:
2420:
2417:
2414:
2411:
2408:
2405:
2402:
2399:
2398:
2395:
2392:
2389:
2386:
2374:
2373:
2369:
2366:
2363:
2360:
2357:
2354:
2351:
2348:
2345:
2344:
2341:
2338:
2335:
2332:
2319:
2318:
2314:
2311:
2308:
2305:
2304:
2301:
2298:
2295:
2292:
2274:
2257:
2240:
2230:
2229:
2225:
2222:
2221:
2218:
2215:
2212:
2209:
2175:
2158:
2142:
2126:
2116:
2115:
2111:
2108:
2105:
2102:
2101:
2098:
2095:
2092:
2089:
2029:
2028:
2024:
2021:
2018:
2015:
2014:
2011:
2008:
2005:
2002:
1985:
1984:
1981:
1978:
1975:
1972:
1968:
1965:
1962:
1961:
1947:
1942:
1941:
1937:
1934:
1931:
1928:
1925:
1922:
1919:
1916:
1913:
1910:
1907:
1904:
1903:
1900:
1897:
1894:
1891:
1884:
1880:
1876:
1872:
1867:
1855:
1854:
1850:
1847:
1844:
1841:
1838:
1837:
1834:
1831:
1828:
1825:
1818:
1811:
1803:
1802:
1799:
1796:
1793:
1790:
1787:
1784:
1781:
1778:
1775:
1772:
1769:
1766:
1763:
1760:
1756:
1753:
1750:
1747:
1744:
1741:
1738:
1735:
1732:
1729:
1726:
1723:
1722:
1719:
1716:
1713:
1710:
1707:
1696:
1693:
1669:
1668:
1665:
1662:
1659:
1656:
1653:
1650:
1647:
1644:
1641:
1638:
1634:
1631:
1628:
1625:
1622:
1619:
1616:
1613:
1610:
1607:
1604:
1601:
1600:
1597:
1594:
1591:
1588:
1585:
1574:
1572:
1551:
1550:introduced the
1515:
1498:
1495:
1492:
1489:
1486:
1483:
1464:
1461:
1458:
1455:
1452:
1449:
1446:
1443:
1424:
1421:
1418:
1415:
1406:
1403:
1400:
1397:
1361:
1358:
1355:
1352:
1349:
1346:
1343:
1340:
1337:
1333:does not exist
1295:
1292:
1289:
1286:
1283:
1280:
1277:
1274:
1271:
1210:
1207:
1204:
1201:
1198:
1195:
1192:
1189:
1186:
1126:
1123:
1120:
1117:
1114:
1045:
1042:
1039:
1036:
1033:
986:
981:
980:
977:
974:
971:
968:
965:
962:
959:
956:
953:
950:
947:
944:
941:
938:
935:
932:
929:
926:
923:
920:
917:
914:
911:
908:
905:
902:
899:
896:
893:
890:
887:
884:
881:
878:
875:
872:
869:
866:
863:
860:
857:
854:
851:
848:
845:
842:
839:
836:
833:
830:
827:
824:
805:
770:
769:
766:
763:
760:
757:
754:
751:
748:
745:
742:
739:
736:
733:
730:
727:
724:
721:
718:
715:
712:
709:
706:
703:
700:
697:
690:
679:
674:
673:
670:
667:
664:
661:
658:
655:
652:
649:
646:
643:
640:
637:
634:
631:
628:
625:
622:
619:
616:
613:
610:
607:
604:
601:
598:
595:
574:
573:
570:
567:
564:
561:
558:
555:
552:
549:
546:
543:
540:
537:
534:
531:
528:
525:
522:
519:
501:
495:
494:
491:
488:
485:
482:
479:
476:
473:
470:
467:
464:
461:
458:
455:
452:
449:
446:
443:
440:
437:
434:
431:
428:
425:
422:
419:
416:
413:
410:
407:
404:
401:
395:
394:
391:
388:
385:
382:
379:
376:
373:
370:
367:
364:
361:
358:
355:
352:
325:
317:
310:
304:
297:
293:
289:
283:
276:
272:
268:
264:
257:
251:
242:
238:
232:
224:
220:
216:
194:
190:
186:
178:
174:
172:
160:
152:
140:
128:
120:
110:
104:
87:
78:query optimizer
69:
57:
50:database tables
28:
23:
22:
15:
12:
11:
5:
6877:
6867:
6866:
6849:
6848:
6846:
6845:
6840:
6835:
6830:
6825:
6820:
6815:
6810:
6805:
6799:
6797:
6793:
6792:
6790:
6789:
6784:
6778:
6776:
6772:
6771:
6769:
6768:
6761:
6754:
6747:
6740:
6733:
6726:
6719:
6712:
6705:
6698:
6691:
6684:
6677:
6670:
6663:
6656:
6649:
6642:
6635:
6627:
6625:
6619:
6618:
6616:
6615:
6610:
6605:
6600:
6595:
6590:
6585:
6580:
6575:
6570:
6565:
6559:
6557:
6553:
6552:
6545:
6544:
6537:
6530:
6522:
6516:
6515:
6510:
6505:
6500:
6495:
6490:
6482:
6481:External links
6479:
6478:
6477:
6472:
6469:
6466:
6465:
6456:
6447:
6421:
6410:
6394:
6371:
6355:
6336:
6312:
6303:
6288:
6272:
6271:
6269:
6266:
6152:
6051:
6045:
6042:
6036:
6033:
6031:
6030:
6027:
6024:
6021:
5898:
5894:
5797:
5793:
5790:
5785:'John'
5693:
5689:
5686:
5683:
5679:'John'
5587:
5583:
5578:
5575:
5559:
5511:
5483:
5480:
5477:
5476:
5473:
5341:
5338:
5242:
5239:
5167:
5163:
5162:
5159:
5039:
5036:
4952:
4949:
4889:
4885:
4884:
4881:
4773:
4770:
4698:
4695:
4647:
4643:
4642:
4637:
4529:
4526:
4454:
4451:
4403:
4399:
4398:
4383:
4266:
4263:
4182:
4179:
4122:
4118:
4117:
4114:
4113:Previous Page
4111:
4108:
4102:
4101:
4098:
4097:
4096:
4077:
4058:
4042:
4039:
4033:
4032:
4029:
3894:
3890:
3889:
3886:
3736:
3732:
3731:
3728:
3617:
3613:
3612:
3609:
3477:
3473:
3472:
3469:
3349:
3345:
3344:
3341:
3278:
3274:
3273:
3266:
3206:
3202:
3201:
3192:
3132:
3128:
3127:
3112:
3040:
3036:
3035:
3032:
3026:
3025:
3022:
3009:
3006:
3000:
2999:
2996:
2918:
2914:
2913:
2910:
2844:
2840:
2839:
2836:
2779:
2775:
2774:
2771:
2717:
2713:
2712:
2707:
2653:
2649:
2648:
2633:
2570:
2566:
2565:
2562:
2556:
2555:
2553:{begin_base_0}
2545:
2536:
2533:
2497:
2495:
2494:
2484:
2479:
2476:
2475:
2474:
2471:{begin_base_0}
2468:
2462:
2454:
2451:
2442:
2439:
2436:
2435:
2429:
2385:
2381:
2380:
2375:
2331:
2327:
2326:
2320:
2291:
2287:
2286:
2281:
2271:
2270:
2264:
2254:
2253:
2247:
2237:
2236:
2231:
2208:
2204:
2203:
2182:
2172:
2171:
2165:
2155:
2154:
2149:
2139:
2138:
2133:
2123:
2122:
2117:
2088:
2084:
2083:
2030:
2001:
1997:
1996:
1986:
1960:
1946:
1943:
1890:
1824:
1810:
1807:
1706:
1692:
1689:
1584:
1571:
1568:
1544:
1543:
1536:
1514:
1511:
1388:
1387:
1384:
1383:
1380:
1376:
1375:
1372:
1365:
1334:
1330:
1329:
1326:
1325:
1322:
1318:
1317:
1314:
1310:
1309:
1306:
1299:
1268:
1265:
1264:
1261:
1257:
1256:
1253:
1249:
1248:
1245:
1237:
1236:
1233:
1232:
1229:
1225:
1224:
1221:
1214:
1183:
1180:
1179:
1176:
1172:
1171:
1168:
1164:
1163:
1160:
1152:
1151:
1148:
1147:
1143:
1142:
1138:
1137:
1130:
1111:
1108:
1107:
1104:
1100:
1099:
1096:
1092:
1091:
1088:
1080:
1079:
1076:
1075:
1072:
1068:
1067:
1064:
1060:
1059:
1056:
1049:
1030:
1027:
1026:
1023:
1019:
1018:
1015:
1011:
1010:
1007:
999:
998:
995:
992:
985:
982:
823:
804:
801:
799:computations.
696:
678:
675:
594:
518:
499:
400:
351:
322:
321:
314:
301:
280:
261:
248:
171:
168:
167:
166:
158:
150:
138:
126:
118:
102:
26:
9:
6:
4:
3:
2:
6876:
6865:
6862:
6861:
6859:
6844:
6841:
6839:
6836:
6834:
6831:
6829:
6826:
6824:
6821:
6819:
6816:
6814:
6811:
6809:
6806:
6804:
6801:
6800:
6798:
6794:
6788:
6785:
6783:
6780:
6779:
6777:
6773:
6766:
6762:
6759:
6755:
6752:
6748:
6745:
6741:
6738:
6734:
6731:
6727:
6724:
6720:
6717:
6713:
6710:
6706:
6703:
6699:
6696:
6692:
6689:
6685:
6682:
6678:
6675:
6671:
6668:
6664:
6661:
6657:
6654:
6650:
6647:
6643:
6640:
6636:
6633:
6629:
6628:
6626:
6624:
6620:
6614:
6611:
6609:
6606:
6604:
6601:
6599:
6596:
6594:
6591:
6589:
6586:
6584:
6581:
6579:
6576:
6574:
6571:
6569:
6566:
6564:
6561:
6560:
6558:
6554:
6550:
6543:
6538:
6536:
6531:
6529:
6524:
6523:
6520:
6514:
6511:
6509:
6506:
6504:
6501:
6499:
6496:
6494:
6491:
6488:
6485:
6484:
6475:
6474:
6460:
6451:
6436:
6432:
6425:
6419:
6414:
6407:
6397:
6395:9780074637081
6391:
6387:
6386:
6381:
6375:
6368:
6358:
6356:9781612905686
6352:
6348:
6347:
6340:
6325:
6324:
6316:
6307:
6299:
6292:
6284:
6277:
6273:
6150:
6148:
6049:
6041:
6028:
6025:
6022:
5895:
5794:
5791:
5690:
5687:
5684:
5585:
5584:
5582:
5574:
5557:
5555:
5550:
5548:
5509:
5508:For example,
5506:
5504:
5500:
5495:
5493:
5489:
5474:
5339:
5240:
5165:
5164:
5160:
5037:
4950:
4887:
4886:
4882:
4771:
4696:
4645:
4644:
4638:
4527:
4452:
4401:
4400:
4385:SQL ANSI 2008
4384:
4264:
4180:
4120:
4119:
4115:
4112:
4109:
4106:
4105:
4099:
4087:is less than
4078:
4059:
4052:
4051:
4045:
4044:
4038:
4030:
3892:
3891:
3887:
3734:
3733:
3729:
3727:
3615:
3614:
3610:
3475:
3474:
3470:
3347:
3346:
3342:
3276:
3275:
3267:
3204:
3203:
3193:
3130:
3129:
3114:SQL ANSI 2008
3113:
3038:
3037:
3033:
3030:
3029:
3023:
3012:
3011:
3005:
2997:
2916:
2915:
2911:
2842:
2841:
2837:
2777:
2776:
2772:
2715:
2714:
2708:
2651:
2650:
2635:SQL ANSI 2008
2634:
2568:
2567:
2563:
2560:
2559:
2546:
2539:
2538:
2485:
2482:
2481:
2469:
2465:{page_number}
2463:
2457:
2456:
2450:
2447:
2433:
2430:
2383:
2382:
2379:
2376:
2329:
2328:
2324:
2321:
2289:
2288:
2285:
2282:
2278:
2273:
2272:
2268:
2265:
2261:
2256:
2255:
2251:
2248:
2244:
2239:
2238:
2235:
2232:
2206:
2205:
2202:
2198:
2194:
2190:
2186:
2185:MS SQL Server
2183:
2179:
2174:
2173:
2169:
2166:
2162:
2157:
2156:
2153:
2150:
2146:
2141:
2140:
2137:
2134:
2130:
2125:
2124:
2121:
2118:
2086:
2085:
2082:
2078:
2074:
2070:
2066:
2062:
2058:
2054:
2050:
2046:
2042:
2038:
2034:
2031:
1999:
1998:
1994:
1990:
1989:MS SQL Server
1987:
1958:
1957:
1954:
1952:
1888:
1870:
1862:
1860:
1822:
1816:
1806:
1704:
1702:
1688:
1686:
1682:
1678:
1674:
1582:
1580:
1567:
1565:
1561:
1555:
1549:
1541:
1537:
1534:
1531:
1530:
1529:
1527:
1524:
1519:
1510:
1507:
1503:
1479:
1477:
1476:
1471:
1439:
1437:
1433:
1432:
1411:
1395:
1381:
1378:
1377:
1373:
1370:
1369:
1335:
1331:
1323:
1320:
1319:
1315:
1312:
1311:
1307:
1304:
1303:
1269:
1262:
1259:
1258:
1254:
1251:
1250:
1246:
1243:
1242:
1238:
1230:
1227:
1226:
1222:
1219:
1218:
1184:
1177:
1174:
1173:
1169:
1166:
1165:
1161:
1158:
1157:
1153:
1145:
1144:
1140:
1139:
1135:
1134:
1112:
1105:
1102:
1101:
1097:
1094:
1093:
1089:
1086:
1085:
1081:
1073:
1070:
1069:
1065:
1062:
1061:
1057:
1054:
1053:
1031:
1024:
1021:
1020:
1016:
1013:
1012:
1008:
1005:
1004:
1000:
996:
993:
990:
989:
821:
817:
815:
811:
803:Derived table
800:
798:
794:
790:
786:
782:
777:
775:
694:
688:
684:
592:
590:
586:
582:
577:
516:
514:
510:
506:
498:
398:
349:
347:
343:
339:
335:
331:
315:
307:
302:
286:
281:
262:
254:
249:
245:
235:
230:
229:
228:
213:
211:
207:
204:to carry out
203:
198:
184:
163:
159:
155:
151:
148:
143:
139:
136:
131:
127:
123:
119:
116:
107:
103:
100:
97:
93:
86:
85:
84:
81:
79:
75:
67:
63:
55:
51:
46:
44:
40:
36:
33:
19:
6864:SQL keywords
6729:
6459:
6450:
6438:. Retrieved
6434:
6424:
6413:
6405:
6399:. Retrieved
6384:
6380:Leon, Alexis
6374:
6366:
6360:. Retrieved
6345:
6339:
6328:. Retrieved
6322:
6315:
6306:
6291:
6276:
6144:
6047:
6038:
5580:
5572:
5553:
5551:
5546:
5544:
5507:
5496:
5485:
4093:{unique_key}
4085:{unique_key}
4074:{unique_key}
4066:{unique_key}
4036:
4022:begin_base_0
3995:begin_base_0
3861:begin_base_0
3747:begin_base_0
3725:
3718:begin_base_0
3584:begin_base_0
3488:begin_base_0
3453:begin_base_0
3360:begin_base_0
3334:begin_base_0
3247:begin_base_0
3185:begin_base_0
3081:begin_base_0
3013:Select only
3003:
2983:begin_base_0
2855:begin_base_0
2823:begin_base_0
2728:begin_base_0
2694:begin_base_0
2614:begin_base_0
2445:
2444:
2276:
2259:
2242:
2177:
2160:
2144:
2128:
1992:
1951:simple limit
1950:
1948:
1875:clause. The
1863:
1856:
1812:
1804:
1700:
1694:
1684:
1680:
1676:
1670:
1579:simple table
1578:
1573:
1563:
1556:
1545:
1538:by adding a
1520:
1516:
1508:
1504:
1480:
1473:
1440:
1429:
1412:
1393:
1391:
818:
813:
809:
806:
778:
771:
686:
680:
588:
584:
580:
578:
575:
512:
508:
504:
502:
496:
396:
345:
341:
337:
333:
329:
323:
214:
199:
173:
82:
52:or database
47:
34:
29:
5564:OVER_CLAUSE
4107:First Page
4089:{first_val}
1885:FETCH FIRST
1868:FETCH FIRST
1819:FETCH FIRST
1767:person_name
1697:RANK() OVER
1552:FETCH FIRST
810:inline view
581:select list
559:Book_author
468:Book_author
450:Book_author
342:select list
195:SELECT INTO
6808:Foundation
6782:Edgar Codd
6401:2015-10-21
6362:2015-10-21
6330:2007-06-17
6268:References
5519:population
5475:Oracle 11
5466:unique_key
5418:unique_key
5391:unique_key
5307:unique_key
5280:unique_key
5208:unique_key
5143:unique_key
5119:unique_key
5092:unique_key
5020:unique_key
4993:unique_key
4933:unique_key
4874:unique_key
4850:unique_key
4823:unique_key
4763:unique_key
4736:unique_key
4688:unique_key
4630:unique_key
4594:unique_key
4567:unique_key
4507:unique_key
4480:unique_key
4432:unique_key
4397:Mimer SQL
4393:Oracle 12c
4387:PostgreSQL
4376:unique_key
4331:unique_key
4304:unique_key
4235:unique_key
4208:unique_key
4151:unique_key
4110:Next Page
4070:{last_val}
4031:Oracle 11
3971:unique_key
3673:unique_key
3652:ROW_NUMBER
3554:unique_key
3423:unique_key
3307:unique_key
3235:unique_key
3198:PostgreSQL
3161:unique_key
3126:Mimer SQL
3122:Oracle 12c
3116:PostgreSQL
3069:unique_key
2998:Oracle 11
2959:unique_key
2894:unique_key
2808:unique_key
2764:unique_key
2682:unique_key
2647:Mimer SQL
2643:Oracle 12c
2637:PostgreSQL
2599:unique_key
2526:unique_key
2243:TOP 20, 10
2049:PostgreSQL
1995:does not)
1813:Since ISO
1660:row_number
1632:row_number
1602:ROW_NUMBER
1431:projection
991:Table "T"
942:Company_Nm
933:Book_Sales
921:Company_Nm
915:Items_Sold
909:Items_Sold
882:company_nm
870:items_sold
677:Subqueries
210:optimizing
137:operation.
117:operation.
101:operation.
99:projection
74:query plan
68:language,
39:result set
6803:Framework
6440:1 October
6149:standard
5990:GroupName
5909:GroupName
5889:GroupName
5808:GroupName
5779:FirstName
5673:FirstName
5531:PARTITION
5403:first_val
5104:first_val
4835:first_val
4579:first_val
4316:first_val
4001:cant_regs
2547:Read the
2193:MS Access
2131:* from T
2069:Polyhedra
1866:supports
1859:Mimer SQL
1761:person_id
1645:tablename
1475:selection
1472:terms, a
789:recursive
635:sales_tax
585:sales_tax
135:selection
6858:Category
6737:Truncate
6709:Order by
6667:Group by
6623:Keywords
6613:SQL:2023
6608:SQL:2016
6603:SQL:2011
6598:SQL:2008
6593:SQL:2006
6588:SQL:2003
6583:SQL:1999
6556:Versions
6147:SQL:1999
5761:LastName
5655:LastName
5499:SQL:2003
5292:last_val
5152:ROWCOUNT
5044:ROWCOUNT
5029:ROWCOUNT
5005:last_val
4957:ROWCOUNT
4942:ROWCOUNT
4894:ROWCOUNT
4748:last_val
4492:last_val
4220:last_val
4116:Dialect
3879:ROWCOUNT
3774:identity
3741:ROWCOUNT
3602:ROWCOUNT
3515:identity
3482:ROWCOUNT
3384:identity
3034:Dialect
2903:ROWCOUNT
2849:ROWCOUNT
2564:Dialect
2323:Firebird
2284:Firebird
2279:* FROM T
2262:* FROM T
2245:* FROM T
2234:Teradata
2201:Teradata
2180:* FROM T
2168:Informix
2152:Informix
2145:FIRST 10
2129:FIRST 10
1966:ROWCOUNT
1877:ORDER BY
1873:ORDER BY
1821:clause.
1815:SQL:2008
1685:sort_key
1681:sort_key
1677:sort_key
1620:sort_key
1566:clause.
1554:clause.
1548:SQL:2008
1526:SQL:2003
984:Examples
797:fixpoint
687:subquery
318:DISTINCT
311:ORDER BY
306:ORDER BY
294:GROUP BY
290:GROUP BY
277:GROUP BY
269:GROUP BY
265:GROUP BY
206:planning
170:Overview
162:ORDER BY
142:GROUP BY
18:Subquery
6775:Related
6723:Prepare
6471:Sources
6296:MySQL.
4641:SQLite
4013:_offset
3923:_offset
3852:_offset
3768:_offset
3709:_offset
3685:_offset
3575:_offset
3509:_offset
3444:_offset
3378:_offset
3272:SQLite
3270:MariaDB
3200:SQLite
3196:MariaDB
2711:SQLite
2432:IBM Db2
2378:IBM Db2
2275:SELECT
2258:SELECT
2241:SELECT
2189:SAP ASE
2176:SELECT
2159:SELECT
2143:SELECT
2127:SELECT
2065:Vertica
2041:MariaDB
2033:Netezza
1911:acolumn
1794:ranking
1754:ranking
1639:columns
1533:cursors
997:Result
553:NATURAL
544:Authors
438:Authors
279:clause.
92:columns
6751:Update
6730:Select
6681:Insert
6674:Having
6653:Delete
6646:Create
6578:SQL-92
6573:SQL-89
6568:SQL-86
6563:SEQUEL
6392:
6353:
6166:values
6154:select
6131:select
6113:select
6095:select
6077:select
6053:select
5993:having
5981:Userid
5969:Userid
5954:groups
5900:select
5880:Userid
5868:Userid
5853:groups
5799:select
5749:Userid
5737:Userid
5722:groups
5695:select
5643:Userid
5631:Userid
5616:groups
5589:select
5501:is an
5436:rownum
5367:select
5355:select
5343:select
5322:rownum
5256:select
5244:select
5223:rownum
5181:select
5169:select
5068:select
5056:select
4969:select
4906:select
4787:select
4775:select
4700:select
4649:select
4543:select
4531:select
4456:select
4405:select
4395:DB2 12
4280:select
4268:select
4184:select
4124:select
4081:{rows}
4062:{rows}
4055:{rows}
4048:{rows}
3986:rownum
3944:SELECT
3911:rownum
3908:SELECT
3896:SELECT
3837:select
3825:unique
3759:select
3643:select
3619:select
3560:select
3500:select
3429:select
3351:Select
3328:OFFSET
3280:Select
3208:Select
3179:OFFSET
3134:Select
3124:DB2 12
3075:OFFSET
3042:Select
3015:{rows}
2974:rownum
2932:SELECT
2920:Select
2867:Select
2781:Select
2719:Select
2655:Select
2645:DB2 12
2572:select
2499:Select
2459:{rows}
2387:SELECT
2333:SELECT
2293:SELECT
2223:SAMPLE
2210:SELECT
2197:SAP IQ
2178:TOP 10
2136:Ingres
2120:Oracle
2106:ROWNUM
2090:SELECT
2057:HSQLDB
2053:SQLite
2022:OFFSET
2003:SELECT
1973:SELECT
1917:OFFSET
1892:SELECT
1883:, and
1881:OFFSET
1826:SELECT
1779:person
1720:SELECT
1708:SELECT
1598:SELECT
1586:SELECT
1484:SELECT
1444:SELECT
1416:SELECT
1398:SELECT
1374:`3*2`
1338:SELECT
1272:SELECT
1187:SELECT
1115:SELECT
1034:SELECT
994:Query
900:SELECT
825:SELECT
734:SELECT
698:SELECT
596:SELECT
520:SELECT
402:SELECT
353:SELECT
326:SELECT
298:HAVING
285:HAVING
225:SELECT
217:SELECT
191:SELECT
187:SELECT
183:tables
179:SELECT
175:SELECT
154:HAVING
115:rename
111:SELECT
88:SELECT
70:SELECT
58:SELECT
43:tables
35:SELECT
6758:Where
6744:Union
6695:Merge
6125:union
6107:union
6089:union
6071:union
5996:count
5984:group
5948:inner
5942:users
5915:count
5883:group
5847:inner
5841:users
5814:count
5752:where
5710:users
5646:where
5610:inner
5604:users
5457:order
5439:<=
5433:where
5409:order
5385:where
5379:table
5325:<=
5319:where
5298:order
5274:where
5268:table
5226:<=
5220:where
5199:order
5193:table
5134:order
5110:order
5086:where
5080:table
5011:order
4987:where
4981:table
4924:order
4918:table
4865:order
4841:order
4817:where
4811:table
4754:order
4730:where
4724:table
4679:order
4673:table
4639:MySQL
4621:order
4603:LIMIT
4585:order
4561:where
4555:table
4513:LIMIT
4498:order
4474:where
4468:table
4438:LIMIT
4423:order
4417:table
4391:Derby
4367:order
4343:FIRST
4340:FETCH
4322:order
4298:where
4292:table
4244:FIRST
4241:FETCH
4226:order
4202:where
4196:table
4160:FIRST
4157:FETCH
4142:order
4136:table
4016:>=
4010:WHERE
3989:<=
3983:WHERE
3962:ORDER
3956:table
3873:#temp
3870:TABLE
3849:where
3846:#temp
3816:ORDER
3810:table
3801:#temp
3706:where
3694:table
3664:order
3596:#temp
3593:TABLE
3572:where
3569:#temp
3545:ORDER
3539:table
3530:#temp
3465:#temp
3462:TABLE
3441:where
3438:#temp
3414:ORDER
3408:table
3399:#temp
3316:LIMIT
3298:order
3292:table
3268:MySQL
3241:LIMIT
3226:order
3220:table
3194:MySQL
3167:LIMIT
3152:order
3146:table
3120:Derby
3090:FETCH
3060:order
3054:table
2977:<=
2971:where
2950:ORDER
2944:table
2885:order
2879:table
2817:LIMIT
2799:order
2793:table
2755:order
2749:table
2709:MySQL
2688:LIMIT
2673:order
2667:table
2641:Derby
2608:FIRST
2605:FETCH
2590:order
2584:table
2517:order
2511:table
2415:FIRST
2412:FETCH
2400:WHERE
2361:FIRST
2358:FETCH
2346:WHERE
2109:<=
2103:WHERE
2037:MySQL
2016:LIMIT
1929:FIRST
1926:FETCH
1905:ORDER
1842:FIRST
1839:FETCH
1797:<=
1791:WHERE
1736:ORDER
1675:: if
1663:<=
1657:WHERE
1614:ORDER
1456:WHERE
1394:query
1371:`1+1`
1284:ORDER
1199:WHERE
960:sales
954:sales
936:GROUP
876:sales
864:sales
858:price
846:title
812:or a
764:title
758:ORDER
743:price
725:price
722:WHERE
713:price
707:title
668:title
662:ORDER
647:price
644:WHERE
617:price
611:price
605:title
589:price
568:title
562:GROUP
529:count
523:title
509:title
489:title
477:GROUP
423:count
417:Title
411:title
389:title
383:ORDER
368:price
365:WHERE
338:title
334:price
273:WHERE
258:WHERE
253:WHERE
130:WHERE
54:views
6765:With
6716:Over
6702:Null
6688:Join
6660:From
6639:Case
6442:2019
6390:ISBN
6351:ISBN
6160:from
6014:>
5951:join
5939:from
5850:join
5838:from
5719:join
5716:left
5707:from
5613:join
5601:from
5567:>
5561:<
5554:OVER
5547:city
5537:city
5525:OVER
5490:for
5445:rows
5424:DESC
5397:<
5373:from
5361:from
5349:from
5331:rows
5286:>
5262:from
5250:from
5232:rows
5187:from
5175:from
5125:DESC
5098:<
5074:from
5062:from
5050:rows
4999:>
4975:from
4963:rows
4912:from
4900:rows
4856:DESC
4829:<
4805:from
4796:rows
4781:from
4742:>
4718:from
4709:rows
4667:from
4658:rows
4609:rows
4600:DESC
4573:<
4549:from
4537:from
4519:rows
4486:>
4462:from
4444:rows
4411:from
4358:ONLY
4355:ROWS
4349:rows
4337:DESC
4310:<
4286:from
4274:from
4259:ONLY
4256:ROWS
4250:rows
4214:>
4190:from
4175:ONLY
4172:ROWS
4166:rows
4130:from
3950:FROM
3938:FROM
3902:FROM
3867:DROP
3855:>
3843:from
3804:from
3798:into
3753:rows
3712:>
3688:from
3658:over
3637:from
3628:rows
3590:DROP
3578:>
3566:from
3533:from
3527:into
3494:rows
3459:DROP
3447:>
3435:from
3402:from
3396:into
3366:rows
3322:rows
3313:ROWS
3286:from
3259:rows
3214:from
3173:rows
3140:from
3108:ONLY
3105:ROWS
3099:rows
3093:NEXT
3087:ROWS
3048:from
3031:SQL
2989:rows
2938:FROM
2926:FROM
2873:from
2861:rows
2829:rows
2814:ROWS
2787:from
2743:from
2734:rows
2700:rows
2661:from
2629:ONLY
2626:ROWS
2620:rows
2578:from
2561:SQL
2505:from
2490:and
2424:ONLY
2421:ROWS
2406:>
2403:ID_T
2393:FROM
2370:ONLY
2367:ROWS
2352:>
2349:ID_T
2339:FROM
2306:ROWS
2299:FROM
2216:FROM
2096:from
2009:FROM
1979:FROM
1938:ONLY
1935:ROWS
1923:ROWS
1914:DESC
1898:FROM
1851:ONLY
1848:ROWS
1832:FROM
1776:FROM
1730:OVER
1724:RANK
1714:FROM
1695:The
1642:FROM
1608:OVER
1592:FROM
1564:OVER
1546:ISO
1535:, or
1490:FROM
1450:FROM
1422:FROM
1404:FROM
1293:DESC
1278:FROM
1193:FROM
1121:FROM
1040:FROM
978:isbn
966:isbn
948:ISBN
930:FROM
927:ISBN
894:JOIN
888:Book
885:FROM
834:isbn
752:Book
749:FROM
728:<
719:Book
716:FROM
701:isbn
650:>
641:Book
638:FROM
599:isbn
556:JOIN
550:Book
547:FROM
513:Book
505:isbn
483:Book
474:isbn
462:isbn
456:Book
447:JOIN
444:Book
441:FROM
405:Book
371:>
362:Book
359:FROM
346:Book
330:Book
316:The
303:The
282:The
263:The
250:The
244:JOIN
239:FROM
234:FROM
231:The
122:FROM
30:The
6549:SQL
6128:all
6110:all
6092:all
6074:all
5770:and
5664:and
5513:sum
5149:SET
5041:SET
5026:SET
4954:SET
4939:SET
4891:SET
4790:TOP
4703:TOP
4652:TOP
3876:SET
3831:key
3780:int
3738:SET
3622:TOP
3599:SET
3479:SET
3354:TOP
2900:SET
2846:SET
2722:TOP
1963:SET
1788:foo
1773:age
1745:ASC
1742:age
1654:foo
1623:ASC
1523:ISO
1521:In
1434:in
1308:C2
1247:C2
1223:C2
1162:C2
1136:C1
1090:C2
1058:C2
1009:C2
903:SUM
737:AVG
691:AVG
653:100
374:100
32:SQL
6860::
6632:As
6433:.
6404:.
6365:.
6244:as
6241:))
6226:),
6211:),
6196:),
6181:),
5987:by
5960:on
5933:as
5886:by
5859:on
5832:as
5728:on
5622:on
5534:BY
5494:.
5460:by
5454:a2
5430:a1
5412:by
5301:by
5202:by
5137:by
5113:by
5014:by
4927:by
4868:by
4844:by
4757:by
4682:by
4624:by
4588:by
4501:by
4426:by
4370:by
4325:by
4229:by
4145:by
3965:BY
3920:as
3819:BY
3703:xx
3682:as
3667:by
3655:()
3548:BY
3521:10
3417:BY
3390:10
3301:by
3229:by
3155:by
3063:by
2953:BY
2888:by
2802:by
2758:by
2676:by
2593:by
2520:by
2418:10
2409:20
2364:10
2355:10
2315:30
2312:TO
2309:20
2226:10
2199:,
2195:,
2191:,
2187:,
2112:10
2079:,
2075:,
2071:,
2067:,
2063:,
2061:H2
2059:,
2055:,
2047:,
2039:,
2035:,
2025:20
2019:10
1969:10
1932:10
1908:BY
1879:,
1861:.
1845:10
1800:10
1785:AS
1751:AS
1739:BY
1727:()
1666:10
1651:AS
1629:AS
1617:BY
1605:()
1499:T2
1493:T1
1459:C1
1419:C1
1382:6
1324:a
1316:b
1305:C1
1290:C1
1287:BY
1263:b
1255:a
1244:C1
1231:a
1220:C1
1202:C1
1178:b
1170:a
1159:C1
1146:2
1141:1
1118:C1
1106:b
1098:a
1087:C1
1074:b
1066:a
1055:C1
1025:b
1017:a
1006:C1
957:ON
939:BY
816:.
776:.
761:BY
665:BY
659:00
632:AS
629:06
591:.
565:BY
541:AS
480:BY
453:ON
435:AS
414:AS
386:BY
380:00
208:,
106:AS
45:.
6541:e
6534:t
6527:v
6444:.
6333:.
6300:.
6285:.
6262:)
6259:b
6256:,
6253:a
6250:(
6247:x
6238:1
6235:,
6232:5
6229:(
6223:1
6220:,
6217:2
6214:(
6208:3
6205:,
6202:1
6199:(
6193:2
6190:,
6187:1
6184:(
6178:1
6175:,
6172:1
6169:(
6163:(
6157:*
6140:1
6137:,
6134:5
6122:1
6119:,
6116:2
6104:3
6101:,
6098:1
6086:2
6083:,
6080:1
6068:b
6065:1
6062:,
6059:a
6056:1
6017:5
6011:)
6008:*
6005:.
6002:g
5999:(
5978:.
5975:u
5972:=
5966:.
5963:g
5957:g
5945:u
5930:)
5927:*
5924:.
5921:g
5918:(
5912:,
5906:.
5903:g
5877:.
5874:u
5871:=
5865:.
5862:g
5856:g
5844:u
5829:)
5826:*
5823:.
5820:g
5817:(
5811:,
5805:.
5802:g
5782:=
5776:.
5773:u
5764:=
5758:.
5755:u
5746:.
5743:u
5740:=
5734:.
5731:g
5725:g
5713:u
5704:*
5701:.
5698:u
5676:=
5670:.
5667:u
5658:=
5652:.
5649:u
5640:.
5637:u
5634:=
5628:.
5625:g
5619:g
5607:u
5598:*
5595:.
5592:g
5540:)
5528:(
5522:)
5516:(
5469:}
5463:{
5451:)
5448:}
5442:{
5427:)
5421:}
5415:{
5406:}
5400:{
5394:}
5388:{
5382:}
5376:{
5370:*
5364:(
5358:*
5352:(
5346:*
5334:}
5328:{
5316:a
5313:)
5310:}
5304:{
5295:}
5289:{
5283:}
5277:{
5271:}
5265:{
5259:*
5253:(
5247:*
5235:}
5229:{
5217:a
5214:)
5211:}
5205:{
5196:}
5190:{
5184:*
5178:(
5172:*
5155:0
5146:}
5140:{
5131:a
5128:)
5122:}
5116:{
5107:}
5101:{
5095:}
5089:{
5083:}
5077:{
5071:*
5065:(
5059:*
5053:}
5047:{
5032:0
5023:}
5017:{
5008:}
5002:{
4996:}
4990:{
4984:}
4978:{
4972:*
4966:}
4960:{
4945:0
4936:}
4930:{
4921:}
4915:{
4909:*
4903:}
4897:{
4877:}
4871:{
4862:a
4859:)
4853:}
4847:{
4838:}
4832:{
4826:}
4820:{
4814:}
4808:{
4802:*
4799:}
4793:{
4784:(
4778:*
4766:}
4760:{
4751:}
4745:{
4739:}
4733:{
4727:}
4721:{
4715:*
4712:}
4706:{
4691:}
4685:{
4676:}
4670:{
4664:*
4661:}
4655:{
4633:}
4627:{
4618:a
4615:)
4612:}
4606:{
4597:}
4591:{
4582:}
4576:{
4570:}
4564:{
4558:}
4552:{
4546:*
4540:(
4534:*
4522:}
4516:{
4510:}
4504:{
4495:}
4489:{
4483:}
4477:{
4471:}
4465:{
4459:*
4447:}
4441:{
4435:}
4429:{
4420:}
4414:{
4408:*
4379:}
4373:{
4364:a
4361:)
4352:}
4346:{
4334:}
4328:{
4319:}
4313:{
4307:}
4301:{
4295:}
4289:{
4283:*
4277:(
4271:*
4253:}
4247:{
4238:}
4232:{
4223:}
4217:{
4211:}
4205:{
4199:}
4193:{
4187:*
4169:}
4163:{
4154:}
4148:{
4139:}
4133:{
4127:*
4025:}
4019:{
4007:)
4004:}
3998:+
3992:{
3980:a
3977:)
3974:}
3968:{
3959:}
3953:{
3947:*
3941:(
3935:*
3932:.
3929:a
3926:,
3917:1
3914:-
3905:(
3899:*
3882:0
3864:}
3858:{
3840:*
3834:}
3828:-
3822:{
3813:}
3807:{
3795:)
3792:1
3789:,
3786:1
3783:,
3777:(
3771:=
3765:,
3762:*
3756:}
3750:+
3744:{
3721:}
3715:{
3700:)
3697:}
3691:{
3679:)
3676:}
3670:{
3661:(
3649:,
3646:*
3640:(
3634:*
3631:}
3625:{
3605:0
3587:}
3581:{
3563:*
3557:}
3551:{
3542:}
3536:{
3524:)
3518:(
3512:=
3506:,
3503:*
3497:}
3491:+
3485:{
3456:}
3450:{
3432:*
3426:}
3420:{
3411:}
3405:{
3393:)
3387:(
3381:=
3375:,
3372:*
3369:}
3363:+
3357:{
3337:}
3331:{
3325:}
3319:{
3310:}
3304:{
3295:}
3289:{
3283:*
3262:}
3256:{
3253:,
3250:}
3244:{
3238:}
3232:{
3223:}
3217:{
3211:*
3188:}
3182:{
3176:}
3170:{
3164:}
3158:{
3149:}
3143:{
3137:*
3102:}
3096:{
3084:}
3078:{
3072:}
3066:{
3057:}
3051:{
3045:*
3021:)
2992:}
2986:+
2980:{
2968:a
2965:)
2962:}
2956:{
2947:}
2941:{
2935:*
2929:(
2923:*
2906:0
2897:}
2891:{
2882:}
2876:{
2870:*
2864:}
2858:+
2852:{
2832:}
2826:+
2820:{
2811:}
2805:{
2796:}
2790:{
2784:*
2767:}
2761:{
2752:}
2746:{
2740:*
2737:}
2731:+
2725:{
2703:}
2697:+
2691:{
2685:}
2679:{
2670:}
2664:{
2658:*
2623:}
2617:+
2611:{
2602:}
2596:{
2587:}
2581:{
2575:*
2544:)
2529:}
2523:{
2514:}
2508:{
2502:*
2396:T
2390:*
2342:T
2336:*
2302:T
2296:*
2219:T
2213:*
2099:T
2093:*
2012:T
2006:*
1982:T
1976:*
1920:0
1901:T
1895:*
1835:T
1829:*
1782:)
1770:,
1764:,
1757:,
1748:)
1733:(
1717:(
1711:*
1701:n
1648:)
1635:,
1626:)
1611:(
1595:(
1589:*
1496:,
1487:*
1465:1
1462:=
1453:T
1447:*
1425:T
1407:T
1401:*
1379:2
1362:;
1359:2
1356:*
1353:3
1350:,
1347:1
1344:+
1341:1
1321:1
1313:2
1296:;
1281:T
1275:*
1260:2
1252:1
1228:1
1211:;
1208:1
1205:=
1196:T
1190:*
1175:2
1167:1
1127:;
1124:T
1103:2
1095:1
1071:2
1063:1
1046:;
1043:T
1037:*
1022:2
1014:1
975:.
972:b
969:=
963:.
951:)
945:,
924:,
918:,
912:)
906:(
897:(
891:b
879:.
873:,
867:.
861:,
855:.
852:b
849:,
843:.
840:b
837:,
831:.
828:b
767:;
755:)
746:)
740:(
731:(
710:,
704:,
671:;
656:.
626:.
623:0
620:*
614:,
608:,
602:,
571:;
538:)
535:*
532:(
526:,
492:;
486:.
471:.
465:=
459:.
432:)
429:*
426:(
420:,
408:.
392:;
377:.
356:*
221:*
20:)
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.