MySQL常用查询

建库建表准备环境

create database shop;

use shop;

CREATE TABLE shop (
    article INT UNSIGNED  DEFAULT '0000' NOT NULL,
    dealer CHAR(20) DEFAULT '' NOT NULL,
    price DECIMAL(16,2) DEFAULT '0.00' NOT NULL,
    PRIMARY KEY(article, dealer));

INSERT INTO shop VALUES
    (1,'A',3.45),(1,'B',3.99),(2,'A',10.99),(3,'B',1.45),
    (3,'C',1.69),(3,'D',1.25),(4,'D',19.95);

查看表数据

select max(article) as article from shop;

+---------+
| article |
+---------+
|       4 |
+---------+

运用子查询

select article,dealer,price from shop where price = (select ma