- 博客(5)
- 收藏
- 关注
原创 MySQL LIMIT子句
1.SELECT customernumber, customername, creditlimit FROM customers ORDER BY creditlimit DESC LIMIT 5; 以升序排列creditlimit 获取前五的数据 DESC 升序
2018-06-13 18:57:50 390
原创 MySQL WHERE语句
1.SELECT lastname, firstname, jobtitle FROM employees WHERE jobtitle = 'Sales Rep';WHERE : 后面加条件2.SELECT lastname, firstname, jobtitle FROM employees WHERE jobtitle = 'Sales ...
2018-06-13 18:38:05 293
原创 MySQL LIKE运算符
1.SELECT employeeNumber, lastName, firstName FROM employees WHERE firstName LIKE 'a%'; firstName 以a开头的数据2.SELECT employeeNumber, lastName, firstName FROM employees WHERE firs...
2018-06-13 18:37:48 468
原创 MySQL BETWEEN运算符
1.SELECT productCode, productName, buyPrice FROM products WHERE buyPrice BETWEEN 90 AND 100; 在90和100之间 BETWEEN : 在…之间
2018-06-13 18:23:38 295
原创 MySQL DISTINCT语句
1.SELECT lastname FROM employees ORDER BY lastname; ORDER BY : 默认排序 2.SELECT DISTINCT lastname FROM employees ORDER BY lastname;SELECT DISTINCT : 删除重复3.SELECT DISTINCT state, cit...
2018-06-13 00:58:52 259
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人