杭州交通信息网森系的英文网名:关于sql的一个小问题
来源：百度文库 编辑：杭州交通信息网 时间：2024/05/01 21:53:31
SQL ="SELECT c_firstname, c_lastname, c_email FROM customers WHERE c_email IS
NOT NULL AND c_purchase = '1' OR c_purchase = '2' AND c_lastname LIKE
'A%'"
多行语句
SQL = "SELECT c_firstname, c_lastname, c_emailaddress, c_phone"
SQL = SQL & " FROM customers"
SQL = SQL & " WHERE c_firstname LIKE 'A%' and c_emailaddress NOT NULL"
SQL = SQL & " ORDER BY c_lastname, c_firstname"
如果两句得到同一个结果，那么第一句中何处规定了数据导出的顺序，也就是第二种表达方式中的
SQL = SQL & " ORDER BY c_lastname, c_firstname"
NOT NULL AND c_purchase = '1' OR c_purchase = '2' AND c_lastname LIKE
'A%'"
多行语句
SQL = "SELECT c_firstname, c_lastname, c_emailaddress, c_phone"
SQL = SQL & " FROM customers"
SQL = SQL & " WHERE c_firstname LIKE 'A%' and c_emailaddress NOT NULL"
SQL = SQL & " ORDER BY c_lastname, c_firstname"
如果两句得到同一个结果，那么第一句中何处规定了数据导出的顺序，也就是第二种表达方式中的
SQL = SQL & " ORDER BY c_lastname, c_firstname"
那是碰巧输出结果一样，你换一种排序的方式肯定输出结果就不同了