from student where sschool number not in(‘B57’,’A_01’,,C82) order by sschool number; 例1.9查询身份证号以“110”开始的学 生的所有信息。 Select from student where id card like 110 例1.10査询最高和最低的贷款金额。 Select min(amount) as amountofmin, max(amount)as amountofmax from loanfrom student where sschool_number not in (‘B_57’ , ’A_01’ , ’C_82’) order by sschool_number; 例1． 9 查询身份证号以“110”开始的学 生的所有信息。 Select * from student where id_card like ‘110*’; 例1． 10 查询最高和最低的贷款金额。 Select min(amount) as amountofmin, max(amount) as amountofmax from loan;