Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update the SQL language documentation to talk about SELECT DISTINCT. (CVS 748) |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
ef7116751ddc4e82228c115b0a332ffb |
| User & Date: | drh 2002-09-12 14:08:32.000 |
Context
|
2002-09-14
| ||
| 12:04 | Rename all tests so that the first part of the test name corresponds to the file that contains that test. This makes it much easier to find a particular test after it fail. (CVS 749) (check-in: 6cb80ae10a user: drh tags: trunk) | |
|
2002-09-12
| ||
| 14:08 | Update the SQL language documentation to talk about SELECT DISTINCT. (CVS 748) (check-in: ef7116751d user: drh tags: trunk) | |
|
2002-09-08
| ||
| 17:23 | Fix for ticket #147: Honor the ORDER BY and LIMIT clauses in a SELECT even if the destination of that SELECT is a subroutine call. (CVS 747) (check-in: 23fe36c7e8 user: drh tags: trunk) | |
Changes
Changes to www/lang.tcl.
1 2 3 | # # Run this Tcl script to generate the sqlite.html file. # | | | 1 2 3 4 5 6 7 8 9 10 11 |
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: lang.tcl,v 1.46 2002/09/12 14:08:32 drh Exp $}
puts {<html>
<head>
<title>Query Language Understood By SQLite</title>
</head>
<body bgcolor=white>
<h1 align=center>
|
| ︙ | ︙ | |||
1156 1157 1158 1159 1160 1161 1162 |
<a href="#insert">INSERT command</a> documentation for additional
information.</p>
}
Section SELECT select
Syntax {sql-statement} {
| | | 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 |
<a href="#insert">INSERT command</a> documentation for additional
information.</p>
}
Section SELECT select
Syntax {sql-statement} {
SELECT [DISTINCT] <result> [FROM <table-list>]
[WHERE <expr>]
[GROUP BY <expr-list>]
[HAVING <expr>]
[<compound-op> <select>]*
[ORDER BY <sort-expr-list>]
[LIMIT <integer> [OFFSET <integer>]]
} {result} {
|
| ︙ | ︙ |