MySql
匿名侠士
非典型的搬砖工
展开
-
Second Highest Salary
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原创 2015-04-25 17:53:31 · 394 阅读 · 0 评论 -
Combine Two Tables
Combine Two Tables Table: Person+-------------+---------+| Column Name | Type |+-------------+---------+| PersonId | int || FirstName | varchar || LastName | varchar |原创 2015-04-25 17:52:27 · 515 阅读 · 0 评论 -
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原创 2016-12-30 17:47:06 · 496 阅读 · 0 评论