~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/queries.rst

• browse files at revision 1843.2.1
• compare with another revision
• download diff
• download tarball
• view history from revision 1843.2.1

• reverse the comparison (1843.2.1 to 2008)
• stop comparing with revision 2008

Show diffs side-by-side

added

removed

docs/queries.rst

1

 

Executing Queries 

2

 

=================

3

 

 

4

 

Queries retrieve data from a database based on specific criteria. They

5

 

are performed with the declarative SELECT statement, which has no

6

 

persistent effects on the database. SELECT simply retrieves data from

7

 

one or more tables, or expressions.

8

 

 

9

 

A query includes a list of columns to be included in a result set; an example of this would be:  ::

10

 

 

11

 

        SELECT * FROM table_1;

12

 

 

13

 

SELECT * FROM is an example of using SELECT with a clause. Other keywords and clauses include:

14

 

 

15

 

* The FROM clause

16

 

* The WHERE clause

17

 

* The GROUP BY clause

18

 

* The HAVING clause

19

 

* The ORDER BY clause

 

 

b'\\ No newline at end of file'

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1