diff options
| -rw-r--r-- | SI/Resource/Data Science/SQL/MySQL/MySQL.md | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/SI/Resource/Data Science/SQL/MySQL/MySQL.md b/SI/Resource/Data Science/SQL/MySQL/MySQL.md index 1e1a269..b453779 100644 --- a/SI/Resource/Data Science/SQL/MySQL/MySQL.md +++ b/SI/Resource/Data Science/SQL/MySQL/MySQL.md @@ -137,7 +137,7 @@ FROM table_name; #### FROM clause -##### Condition +##### ORDER BY - ORDER BY ... ASCending & DESCending @@ -147,6 +147,8 @@ FROM table_name; ORDER BY column_name ASC / DESC; ``` +##### LIMIT + - LIMIT int ```sql @@ -155,6 +157,8 @@ FROM table_name; LIMIT int; ``` +##### WHERE clause: Condition / Predicates + - condition (cmp: <, <=, >, >=, =, <>) ```sql |