摘要: https://leetcode.com/problems/nth-highest-salary/ATTENTION:limit 子句只能接受int常量,不能接受运算式CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INTBEGINSET N =... 阅读全文
posted @ 2015-08-26 15:42 雪溯 阅读(214) 评论(0) 推荐(0) 编辑
摘要: https://leetcode.com/problems/second-highest-salary/Write a SQL query to get the second highest salary from theEmployeetable.+----+--------+| Id | Sal... 阅读全文
posted @ 2015-08-26 07:58 雪溯 阅读(150) 评论(0) 推荐(0) 编辑
摘要: https://leetcode.com/problems/combine-two-tables/Combine Two TablesTable: Person+-------------+---------+| Column Name | Type |+-------------+-----... 阅读全文
posted @ 2015-08-26 07:53 雪溯 阅读(332) 评论(0) 推荐(0) 编辑