|
Size: 1383
Comment:
|
Size: 1507
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 3: | Line 3: |
| [[Table of Contents]] 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 |
[[Table of Contents]] 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
Table of Contents 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