mysql查询条件
2024-02-15 17:12:52
```sql
SELECT supplier_name
FROM equipment_supply
WHERE device_type = '目标设备类型';
```
```sql
SELECT product_name
FROM agriculture
WHERE origin = '目标产地';
```
```sql
SELECT patent_name
FROM patent_application
WHERE applicant = '目标申请人';
```
```sql
SELECT device_model
FROM energySaving_equipment
WHERE energy_rating = '级';
```