Question

Sarthak , a student of class 11 created a table of "STUDENT ". Stream and grades are columns of this table. To find the details of the student whose grade is A in either science and commerce stream. To find the details of the students whose grade is A in either science and commerce stream, he wrote the following mysql query, which did not give the desired result
Select*from students where grade is A and stream ='science' and stream='commerce' ;

Answer 1

Answer:

The % wildcard symbol is used in LIKE clause to represent any sequence of none, one or more characters.