每日总结

1.数据库AND & OR 运算符和ORDER BY 关键字

SELECT * FROM Websites WHERE country='CN' AND alexa > 50;

 

ORDER BY：关键字用于对结果集按照一个列或者多个列进行排序。（asc升序，desc降序）

SELECT column_name,column_name
FROM table_name
ORDER BY column_name,column_name ASC|DESC;

 

SELECT * FROM Websites ORDER BY alexa DESC;