leetcode 175. Combine Two Tables
来源:互联网 发布:哪里帮人做网络推广 编辑:程序博客网 时间:2024/05/14 18:39
175. Combine Two Tables
- Total Accepted: 24263
- Total Submissions: 70650
- Difficulty: Easy
Table: Person
+-------------+---------+| Column Name | Type |+-------------+---------+| PersonId | int || FirstName | varchar || LastName | varchar |+-------------+---------+PersonId is the primary key column for this table.
Table: Address
+-------------+---------+| Column Name | Type |+-------------+---------+| AddressId | int || PersonId | int || City | varchar || State | varchar |+-------------+---------+AddressId is the primary key column for this table.
Write a SQL query for a report that provides the following information for each person in the Person table, regardless if there is an address for each of those people:
FirstName, LastName, City, State
# Write your MySQL query statement below# select p.FirstName,p.LastName,a.City,a.State from Person p left join Address a using PersonId;# SELECT p.FirstName, p.LastName, a.City, a.State FROM Person p LEFT JOIN Address a USING (PersonId);SELECT p.FirstName, p.LastName, a.City, a.State FROM Person p LEFT JOIN Address a USING (PersonId);时灵时不灵的,好奇怪。。。有时候平台会报 内部错误。。。
0 0
- LeetCode : 175. Combine Two Tables
- leetcode 175. Combine Two Tables
- leetcode.175. Combine Two Tables
- leetcode 175. Combine Two Tables
- Leetcode 175. Combine Two Tables
- leetcode 175. Combine Two Tables
- 【LeetCode】175. Combine Two Tables
- [LeetCode] 175. Combine Two Tables
- leetcode 175. Combine Two Tables
- leetcode 175. Combine Two Tables
- Combine Two Tables Leetcode
- Leetcode: Combine Two Tables
- [LeetCode]Combine Two Tables
- LeetCode Combine Two Tables
- 【Leetcode】Combine Two Tables
- leetcode 175. Combine Two Tables left join
- 【leetcode Database】175.Combine Two Tables
- 175. Combine Two Tables
- 哪些行业需要用到ABBYY
- JS数组、对象常用方法
- java eclipse修改项目工程名字
- 容器创建工具类
- Mysql语句拼接
- leetcode 175. Combine Two Tables
- iOS7真机测试上下出现黑边
- 使用java命令重启tomcat
- thinkphp jq 实现列表查看更多功能
- 判断二叉查找树是否是平衡二叉树(代码)
- uda1341原理及驱动
- 【HDU5800】To My Girlfriend(DP + 滚动数组)
- Uber为何必须尽快上市:增长即将放缓
- Android——使用ListView显示信息列表