Diff for "SQL_Language"

SQL and phpPgAdmin for BaBase

[:SQL Language - The Basics:The Basics 2]

• {table of contents} 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