摘要：
Write a SQL query to get the second highest salary from the Employee table. For example, given the above Employee table, the query should return 200 a 阅读全文
posted @ 2018-01-19 17:21
__Meng
阅读(226)
评论(0)
推荐(0)
摘要：
There is a table courses with columns: student and class Please list out all classes which have more than or equal to 5 students. For example, the tab 阅读全文
posted @ 2018-01-19 17:03
__Meng
阅读(225)
评论(0)
推荐(0)
摘要：
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 阅读全文
posted @ 2018-01-19 16:50
__Meng
阅读(164)
评论(0)
推荐(0)
摘要：
The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. Given the Em 阅读全文
posted @ 2018-01-19 16:30
__Meng
阅读(115)
评论(0)
推荐(0)
摘要：
Write a SQL query to find all duplicate emails in a table named Person. For example, your query should return the following for the above table: Note: 阅读全文
posted @ 2018-01-19 16:18
__Meng
阅读(144)
评论(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 @ 2018-01-19 15:40
__Meng
阅读(114)
评论(0)
推荐(0)
摘要：
X city opened a new cinema, many people would like to go to this cinema. The cinema also gives out a poster indicating the movies’ ratings and descrip 阅读全文
posted @ 2018-01-19 11:02
__Meng
阅读(149)
评论(0)
推荐(0)
摘要：
There is a table World A country is big if it has an area of bigger than 3 million square km or a population of more than 25 million. Write a SQL solu 阅读全文
posted @ 2018-01-19 10:42
__Meng
阅读(157)
评论(0)
推荐(0)
浙公网安备 33010602011771号