余熙钰的博客

此情可待成追忆,只是当时已惘然!

Combine Two Tables

Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | PersonId | int | | FirstName | varchar | | La...

2015-03-27 14:14:48

阅读数 438

评论数 0

Second Highest Salary

Write a SQL query to get the second highest salary from the Employee table. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 | 2...

2015-03-27 12:53:12

阅读数 335

评论数 0

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. +----+--...

2015-03-27 12:30:55

阅读数 395

评论数 0

Duplicate Emails

Write a SQL query to find all duplicate emails in a table named Person. +----+---------+ | Id | Email | +----+---------+ | 1 | a@b.com | | 2 | c...

2015-03-27 12:22:16

阅读数 375

评论数 0

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 anyth...

2015-03-27 11:42:20

阅读数 411

评论数 0

提示
确定要删除当前文章?
取消 删除
关闭
关闭