【Leetcode】Combine Two Tables
来源:互联网 发布:notepad 安装sql插件 编辑:程序博客网 时间:2024/04/30 16:12
题目链接:https://leetcode.com/problems/combine-two-tables/
题目:
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
思路:
考察join语句
inner join是两表交集
outer join是两表除了交集之外的部分,left是不管左边表满不满足on的条件都在结果中,right同理,full是两表并集
算法:
select FirstName,LastName,City,State from Person p left outer join Address a on p.PersonId=a.PersonId
- Combine Two Tables Leetcode
- Leetcode: Combine Two Tables
- [LeetCode]Combine Two Tables
- LeetCode Combine Two Tables
- 【Leetcode】Combine Two Tables
- 【leetcode SQL】Combine Two Tables
- [LeetCode][Database]Combine Two Tables
- LeetCode OJ Combine Two Tables
- 【Leetcode Database】Combine Two Tables
- 【leetcode】 database Combine Two Tables
- Database Leetcode 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
- 相见恨晚:linux下的c++filt 命令
- 设计文档
- android开发笔记之多媒体—音频和视频的录制
- Android存储(读取)之内存FilesDir存储
- 顺序表实现集合运算
- 【Leetcode】Combine Two Tables
- ubuntu鼠标滚轮方向修改方法(运动方向和滚轮滚动方向一致)
- Python-格式化字符串
- Gym 100712C Street Lamps
- 《java入门第一季》之Date类案例,算一算你的恋爱纪念日
- 链表操作
- 2016"百度之星" - 资格赛(Astar Round1)
- OCP 考完了, 做个记录,分享下经验
- ViewPager,子页面组件绑定OnClick事件,使用DepthPageTransformer动画,事件失效、混乱