摘要：
Write a SQL query to find all numbers that appear at least three times consecutively. For example, given the above Logs table, 1 is the only number th 阅读全文
posted @ 2017-03-02 23:55
wilderness
阅读(222)
评论(0)
推荐(0)
摘要：
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 num 阅读全文
posted @ 2017-03-02 23:53
wilderness
阅读(256)
评论(0)
推荐(0)
摘要：
Write a SQL query to get the nth highest salary from the Employee table. For example, given the above Employee table, the nth highest salary where n = 阅读全文
posted @ 2017-03-02 23:50
wilderness
阅读(234)
评论(0)
推荐(0)
摘要：
Write a SQL query to get the second highest salary from the Employee table. For example, given the above Employee table, the second highest salary is 阅读全文
posted @ 2017-03-02 23:44
wilderness
阅读(175)
评论(0)
推荐(0)
摘要：
Table: Person Table: Address Write a SQL query for a report that provides the following information for each person in the Person table, regardless if 阅读全文
posted @ 2017-03-02 23:43
wilderness
阅读(236)
评论(0)
推荐(0)
浙公网安备 33010602011771号