- 博客(8)
- 资源 (14)
- 收藏
- 关注
原创 题目7:MySQL----------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.+----+-------+| Id | Na
2015-05-24 00:37:24 1418 3
原创 题目7:MySQL----------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 |+----+---------+For
2015-05-24 00:30:29 1013
原创 题目6:MySQL----------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 | Salary |
2015-05-24 00:27:52 1076
原创 题目5:MySQL----------Consecutive Numbers
Write a SQL query to find all numbers that appear at least three times consecutively.+----+-----+# Write your MySQL query statement belowselect distinct Num from ( select Num, c
2015-05-23 23:49:20 1399
原创 题目4:MySQL----------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-05-23 23:46:21 1521
原创 题目3:MySQL----------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-05-23 03:04:06 1662 9
原创 题目2:MySQL----------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 |+----+--------+For exa
2015-05-18 01:58:28 1024
原创 题目1:MySQL----------Combine Two Tables
Table: Person+-------------+---------+| Column Name | Type |+-------------+---------+| PersonId | int || FirstName | varchar || LastName | varchar |+-------------+---------+Per
2015-05-18 00:34:50 1033
基于opecv的肤色检测
2014-08-08
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人