5 lines
320 B
SQL
5 lines
320 B
SQL
|
SELECT id, cultivar_name, firmness, flowering_period FROM bre_germplasm
|
||
|
|
WHERE firmness IN ('还好') OR flowering_period IN ('3月下旬');
|
||
|
|
SELECT id, cultivar_name, firmness FROM bre_germplasm WHERE firmness IS NOT NULL;
|
||
|
|
SELECT id, cultivar_name, flowering_period FROM bre_germplasm WHERE flowering_period IS NOT NULL;
|