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 | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | ef7116751ddc4e82228c115b0a332ffb47a22ae5 |
| User & Date: | drh 2002-09-12 14:08:32 |
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: 6cb80ae1 user: drh tags: trunk | |
|
2002-09-12
| ||
| 14:08 | Update the SQL language documentation to talk about SELECT DISTINCT. (CVS 748) check-in: ef711675 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: 23fe36c7 user: drh tags: trunk | |
Changes
Changes to www/lang.tcl.
1
2
3
4
5
6
7
8
9
10
11
....
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
|
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: lang.tcl,v 1.45 2002/08/25 20:11:19 drh Exp $}
puts {<html>
<head>
<title>Query Language Understood By SQLite</title>
</head>
<body bgcolor=white>
<h1 align=center>
................................................................................
<a href="#insert">INSERT command</a> documentation for additional
information.</p>
}
Section SELECT select
Syntax {sql-statement} {
SELECT <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} {
|
|
|
|
1
2
3
4
5
6
7
8
9
10
11
....
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
|
#
# 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>
................................................................................
<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} {
|