| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 |
- iterates
- Github
- Text mining
- PROJECT
- Python
- self parameter
- matplotlib
- Else
- For loops
- MySQL
- data distribution
- machine learning
- train/test
- pie charts
- SQL
- variables
- line width
- AS
- Text Analytics
- error
- break
- PANDAS
- matplotlib.pyplot
- continue
- Default X points
- multiple lines
- start exercise
- line color
- __init__
- polynomial regression
- Today
- Total
목록AS (2)
Data Science Explorer
[Basic Grammar] SQL Aliases
Aliases are often used to give a table or a column in a table and they are created with AS keyword. Syntax When alias is used on column: SELECT column_name AS alias_name FROM table_name; When alias is used on table: SELECT column_name(s) FROM table_name AS alias_name; Using Aliases with a space character When you want spaces in aliases, you have to use [] or double quotes. SELECT Brandname AS [M..
[Basic Grammar] SQL MIN() and MAX() Functions
The MIN() function gives you the smallest value of the selected column and MAX() gives you the biggest value. Syntax MIN () SELECT MIN(column_name) FROM table_name WHERE condition; MAX() SELECT MAX(column_name) FROM table_name WHERE condition; MIN () Example Find the lowest grade: SELECT MIN(Grade) FROM Students; MAX() Example Find the highest grade: SELECT MAX(Grade) FROM Students; Set Colum Na..