|
Size: 1361
Comment:
|
Size: 1766
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 3: | Line 3: |
| The Basics 2 Case sensitivity 2 Conventions in SQL syntax 2 Quotation marks 2 Data Types 3 Character 3 Number 3 Date 3 Time 3 Retrieving Data from a Table 3 Retrieving columns with SELECT and FROM 4 Eliminating duplicate rows with DISTINCT 4 Filtering rows with WHERE 4 Comparisons 5 Combining and negating conditions with AND, OR, and NOT 6 Matching patterns with LIKE 6 Range filtering with BETWEEN 7 List filtering with IN 7 Testing for blanks or nulls with NULL 7 Sorting rows with ORDER BY 8 Creating column aliases with AS 8 Operators and Functions 9 Performing Arithmetic Operations 9 Summarizing and Grouping Data 9 Aggregate Functions 9 COUNT 9 MIN and MAX 10 AVG 10 SUM 10 FLOOR and CEILING 10 Grouping rows with GROUP BY 11 Filtering groups with HAVING 11 Retrieving Data from Multiple Tables 12 Qualifying column names 12 Creating joins with JOIN or WHERE 12 Selecting Columns from two or more tables with WHERE 12 Join two or more tables using JOIN 13 Schemas 15 Saving your query result INTO a new table 16 Queries with multiple SELECT statements 16 Temporary tables 16 Deleting tables 16 Importing Tables into your schema 16 Exporting Tables 17 Sandbox 17 Permissions 17 Permissions 18 Views 18 Saving your queries 18 A Couple Useful Queries 19 Calculate Age 19 |
The Basics 2 Case sensitivity 2 Conventions in SQL syntax 2 Quotation marks 2 Data Types 3 Character 3 Number 3 Date 3 Time 3 Retrieving Data from a Table 3 Retrieving columns with SELECT and FROM 4 Eliminating duplicate rows with DISTINCT 4 Filtering rows with WHERE 4 Comparisons 5 Combining and negating conditions with AND, OR, and NOT 6 Matching patterns with LIKE 6 Range filtering with BETWEEN 7 List filtering with IN 7 Testing for blanks or nulls with NULL 7 Sorting rows with ORDER BY 8 Creating column aliases with AS 8 Operators and Functions 9 Performing Arithmetic Operations 9 Summarizing and Grouping Data 9 Aggregate Functions 9 COUNT 9 MIN and MAX 10 AVG 10 SUM 10 FLOOR and CEILING 10 Grouping rows with GROUP BY 11 Filtering groups with HAVING 11 Retrieving Data from Multiple Tables 12 Qualifying column names 12 Creating joins with JOIN or WHERE 12 Selecting Columns from two or more tables with WHERE 12 Join two or more tables using JOIN 13 Schemas 15 Saving your query result INTO a new table 16 Queries with multiple SELECT statements 16 Temporary tables 16 Deleting tables 16 Importing Tables into your schema 16 Exporting Tables 17 Sandbox 17 Permissions 17 Permissions 18 Views 18 Saving your queries 18 A Couple Useful Queries 19 Calculate Age 19 |
SQL and phpPgAdmin for BaBase
The Basics 2
Case sensitivity 2
Conventions in SQL syntax 2
Quotation marks 2
- Data Types 3
Character 3
Number 3
Date 3
Time 3
Retrieving Data from a Table 3
Retrieving columns with SELECT and FROM 4
Eliminating duplicate rows with DISTINCT 4
Filtering rows with WHERE 4
Comparisons 5
Combining and negating conditions with AND, OR, and NOT 6
Matching patterns with LIKE 6
Range filtering with BETWEEN 7
List filtering with IN 7
Testing for blanks or nulls with NULL 7
Sorting rows with ORDER BY 8
Creating column aliases with AS 8
Operators and Functions 9
Performing Arithmetic Operations 9
Summarizing and Grouping Data 9
Aggregate Functions 9
COUNT 9
MIN and MAX 10
- AVG 10
SUM 10
FLOOR and CEILING 10
Grouping rows with GROUP BY 11
Filtering groups with HAVING 11
- Retrieving Data from Multiple Tables 12
Qualifying column names 12
- Creating joins with JOIN or WHERE 12
Selecting Columns from two or more tables with WHERE 12
Join two or more tables using JOIN 13
Schemas 15
Saving your query result INTO a new table 16
Queries with multiple SELECT statements 16
Temporary tables 16
Deleting tables 16
Importing Tables into your schema 16
Exporting Tables 17
Sandbox 17
Permissions 17
Permissions 18
Views 18
Saving your queries 18
A Couple Useful Queries 19
Calculate Age 19