- 博客(9)
- 资源 (4)
- 收藏
- 关注
原创 【leetcode Database】176. Second Highest Salary
题目:Write a SQL query to get the second highest salary from the Employee table.+----+--------+| Id | Salary |+----+--------+| 1 | 100 || 2 | 200 || 3 | 300 |+----+--------+
2016-07-27 15:26:48 4206
原创 【leetcode Database】197. Rising Temperature
题目:Given a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates.+---------+------------+------------------+| Id(INT)
2016-07-27 14:47:50 3685
原创 【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: Customers.+----+-------+
2016-07-27 14:04:22 3485
原创 【leetcode Database】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 |
2016-07-27 11:30:18 4221
原创 【leetcode Database】182. Duplicate Emails
题目:Write a SQL query to find all duplicate emails in a table named Person.+----+---------+| Id | Email |+----+---------+| 1 | a@b.com || 2 | c@d.com || 3 | a@b.com |+----+---------+
2016-07-27 10:52:28 3654
原创 【leetcode Database】175.Combine Two Tables
题目:Table: Person+-------------+---------+| Column Name | Type |+-------------+---------+| PersonId | int || FirstName | varchar || LastName | varchar |+-------------+-----
2016-07-26 17:53:52 3654
原创 【mysql学习笔记】-explain的用法
1.explain的使用方法mysql中的explain命令显示了mysql如何使用索引来处理select语句以及连接表。使用时直接在select语句前加上explain就行了。例子如下:explain select * from orders;运行结果如下:创建索引后的运行结果如下:2.explain每列的解释1)id:select识别符,这是
2016-07-12 16:56:23 3153
原创 【mysql学习笔记】-索引
1.基本概念1)索引的概念:是对数据库表中一列或多列的值进行排序的一种结构,使用索引可快速访问数据表中的特定信息。2)索引的优点:提高查询,联合查询,分级和排序的时间;缺点:索引占空间,维护索引时需要耗费时间。2.索引的底层实现索引的底层有两种实现方式,一种是B树,另一种是哈希表。1)B-Tree:B树是为磁盘或者其他直接存取的辅助存储设备而设计的一种平衡搜索树,B树类似于红黑
2016-07-12 16:50:54 3575
原创 Ajax提交Form表单
1. 背景在java后台开发中,经常要从前端向后台提交表单数据。利用Ajax进行Form表单提交,是很常用的方法。本文主要讲解Ajax提交表单的基本应用。2. Ajax提交表单基本用法ajax()方法是通过HTTP请求加载远程数据。常用参数和方法如下:(1)async:类型:Boolean默认值: true。默认设置下,所有请求均为异步请求。如果需要发送
2016-07-12 16:46:48 1272
jrebel插件
2016-08-30
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人