- 博客(5)
- 收藏
- 关注
RSS订阅原创 MySQL LIMIT子句
1.SELECT customernumber, customername, creditlimitFROM customersORDER BY creditlimit DESCLIMIT 5;以升序排列creditlimit 获取前五的数据 DESC 升序
2018-06-13 18:57:50
421
原创 MySQL WHERE语句
1.SELECT lastname, firstname, jobtitleFROM employeesWHERE jobtitle = 'Sales Rep';WHERE ： 后面加条件2.SELECT lastname, firstname, jobtitleFROM employeesWHERE jobtitle = 'Sales ...
2018-06-13 18:38:05
330
原创 MySQL LIKE运算符
1.SELECT employeeNumber, lastName, firstNameFROM employeesWHERE firstName LIKE 'a%';firstName 以a开头的数据2.SELECT employeeNumber, lastName, firstNameFROM employeesWHERE firs...
2018-06-13 18:37:48
498
原创 MySQL BETWEEN运算符
1.SELECT productCode, productName, buyPriceFROM productsWHERE buyPrice BETWEEN 90 AND 100; 在90和100之间BETWEEN : 在…之间
2018-06-13 18:23:38
331
原创 MySQL DISTINCT语句
1.SELECT lastnameFROM employeesORDER BY lastname;ORDER BY : 默认排序2.SELECT DISTINCT lastnameFROM employeesORDER BY lastname;SELECT DISTINCT : 删除重复3.SELECT DISTINCT state, cit...
2018-06-13 00:58:52
292
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人