Database SQL statement Exercises 5--9

5. Check the record of 85, 86 or 88 in the score table.

Select *  from where inch (+,+)

6, inquires the student table "95031" class or the sex is "the female" the classmate record.

Select *  from where class='95031'or=' female '

7. Query the student table for all records in descending order of class.

Select *  from Order  by desc

8, in CNO Ascending, Degree descending query score all records of the table.

Select *  from Order  by desc

9. Check the number of students in "95031" class.

Select Count (1from where class='95031'

Database SQL statement Exercises 5--9