HTML
CSS
PHP
JavaScript
SQL
Bootstrap
Solidity
jQuery
Git
Chrome DevTools
C++
PythonSQL MAX function returns the biggest data record value from the specified column.
Syntax of SQL MAX
Example
SELECT MAX(col_name)
FROM tbl_name
WHERE conditions;
Pros Main Features
- Simplistic design (no unnecessary information)
- High-quality courses (even the free ones)
- Variety of features
- Nanodegree programs
- Suitable for enterprises
- Paid certificates of completion
Pros Main Features
- Easy to navigate
- No technical issues
- Seems to care about its users
- Huge variety of courses
- 30-day refund policy
- Free certificates of completion
Pros Main Features
- Great user experience
- Offers quality content
- Very transparent with their pricing
- Free certificates of completion
- Focused on data science skills
- Flexible learning timetable
Demo Database
The demo database we'll use in our examples is called Products:
| ID | Name | Supplier_ID | Category_ID | Unit | Price | Unit_in_stock | Unit_on_order |
|---|---|---|---|---|---|---|---|
| 1 | Cucumber | 3 | 3 | 5 crates | 19 | 17 | 16 |
| 2 | Tomato | 3 | 3 | 6 crates | 20 | 24 | Null |
| 3 | Cheese | 3 | 4 | 5 kg boxes | 11 | 11 | 6 |
| 4 | Milk | 4 | 4 | 5 L bottles | 22 | 56 | 12 |
| 5 | Bread | 4 | 4 | 36 boxes | 26 | 26 | 1 |
SQL MAX Example
The code example below pick out the biggest 'PriceID' data record value in the table Products:
