Number course score time
1 Chinese 100 2018
2 mathematics, 99, 2018
3 80 2018 English
4 71 2018
5 100 2018
6 Chinese 80 2018
7 mathematics, 72, 2018
8 89 2018 English
9 61 2018
10 77 2018
(1) I want to list the language results, the following effects:
1 Chinese 100 2018
6 Chinese 80 2018
(2) and query language is higher than or equal to 90 points number.
Requests are greatly instruct me.. Thank you very much!!!!!!!!!!
CodePudding user response:
Select * from tableName where the subject='language';Select * from tableName where the subject='language' and score & gt;=90
CodePudding user response:
Select * from table where the subject='language';Select Numbers from the table where the subject='language' and score & gt;=90
CodePudding user response:
The second floor of the way with respect to OK,CodePudding user response:
1, the SELECT * FROM TB a=WHERE a. subjects' language '
Number 2, and SELECT the FROM TB b
WHERE b. subject="language" AND grades & gt;=90