- 博客(17)
- 收藏
- 关注
RSS订阅原创 selenium2+Python学习记录
自动化测试框架-------（搭建）工具Python以及其中的selenium框架的作用：帮助我们编写更加简单而且好维护的测试用例框架的目录结构：配置文件 数据文件 驱动 日志 报告 测试用例 公共方法 说明性文件，类似通知学习selenium记录1、学习关于页面元素的定位；其中xpath和css分别是屠龙刀和倚天剑。键盘操作和鼠标操作用户传参使用2、页面里包括...
2018-11-01 23:13:45
211
原创 最近使用数据库常见问题1
1、使用group by 进行查询时若select 查询条件里的个数与group by里面的个数不等，会报出不是group by表达式的错误2、单行返回多行子查询错误，就是使用了max函数本来是要查出一条记录的查出了多条，数据库返回不出来所以报这个错误。3、表a与表b进行关联查询时，若表a的条数多余表b的条数，则使用 a.列名=b.列名(+)...
2018-11-01 22:56:37
194
原创 主键冲突
系统报错主键冲突异常 详细信息 [command]= (command ownerId="13541523" ownerName="core" poolName="core" startTime="2015-02-17 09:51:59.010" endTime="1970-01-01 08:00:00.000" cost="-1424137919010" correlation="0
2015-02-22 14:04:47
1696
2
原创 leetcode 178 Rank Scores
Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking number should be the next consecutive integer value.
2015-01-29 23:58:24
1748
原创 leetcode 177 Nth Highest Salary
Write a SQL query to get the nth highest salary from the Employee table.+----+--------+| Id | Salary |+----+--------+| 1 | 100 || 2 | 200 || 3 | 300 |+----+--------+For exampl
2015-01-29 23:49:50
2181
1
原创 leetcode 184,185 Department Top Three Salaries/HIGHEST Salaries
The Employee table holds all employees. Every employee has an Id, and there is also a column for the department Id.+----+-------+--------+--------------+| Id | Name | Salary | DepartmentId |+--
2015-01-28 23:48:01
1243
原创 Rank Scores
Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking number should be the next consecutive integer value.
2015-01-28 23:33:39
454
原创 第n大的薪水
Nth Highest Salary Total Accepted: 710 Total Submissions: 5038My SubmissionsQuestion SolutionWrite a SQL query to get the nth highest salary from the Employee table.+----+---
2015-01-28 23:11:59
999
转载 mysql 中limit的用法
SELECT * FROM table LIMIT [offset,] rows | rows OFFSET offset 在我们使用查询语句的时候，经常要返回前几条或者中间某几行数据，这个时候怎么办呢？不用担心，mysql已经为我们提供了上面这样一个功能。 LIMIT 子句可以被用于强制 SELECT 语句返回指定的记录数。LIMIT 接受一个或两个数字参数。参数必须是一
2015-01-26 22:54:12
547
原创 leetcode 176
Second Highest Salary Total Accepted: 1481 Total Submissions: 6146 My Submissions Question SolutionWrite a SQL query to get the second highest salary from the Employee table.+----+------
2015-01-26 13:02:34
647
1
转载 consecutive numbers 180
[LeetCode]Consecutive Numbers 转账作者‘在线疯狂’，非常感谢‘在线疯狂‘给出的解析。很赞很给力！题目描述：Write a SQL query to find all numbers that appear at least three times consecutively.+----+-----+| Id | Num |+----
2015-01-24 16:54:41
602
1
原创 leetcode 181 Employees Earning More Than Their Managers
The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.+----+-------+--------+-----------+| Id | Name | Salar
2015-01-23 22:05:06
1083
原创 leetcode database 183
Customers Who Never Order （题目标题）Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything.Table
2015-01-22 23:30:36
651
1
原创 发呆不好。。。那就看leetcode吧。第一篇
Duplicate Emails Total Accepted: 457 Total Submissions: 1189My SubmissionsQuestion Solution Write a SQL query to find all duplicate emails in a table named Person.+----+-------
2015-01-20 23:56:15
599
1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人