No cache version.
Caching disabled. Default setting for this page:enabled (code DEF204)If the display is too slow, you can disable the user mode to view the cached version.
Rechercher dans le manuel MySQL
3.6.2 The Row Holding the Maximum of a Certain Column
Task: Find the number, dealer, and price of the most expensive article.
This is easily done with a subquery:
- FROM shop
- +---------+--------+-------+
- | article | dealer | price |
- +---------+--------+-------+
- | 0004 | D | 19.95 |
- +---------+--------+-------+
Other solutions are to use a LEFT JOIN
or to
sort all rows descending by price and get only the first row
using the MySQL-specific LIMIT
clause:
Note
If there were several most expensive articles, each with a
price of 19.95, the LIMIT
solution would
show only one of them.
Can not display this page of the Infobrol website
Type of error (18-01)
Unknown format specifier "&"Please try again in a few minutes…
Steph