文件名称：leetcode下载-Leetcode-SQL-rewrite-using-Python-:这是一个由黄磊创建的记录LeetcodeSQL实践
文件大小：11KB
文件格式：ZIP
更新时间：2024-07-19 13:30:33
系统开源
leetcode下载Leetcode-SQL-rewrite-using-Python- 这是一个由黄磊创建的记录Leetcode SQL实践的仓库。 175. 合并两张表 sql select FirstName, LastName, City, State from Person P left join Address A on P . PersonId = A . PersonId Python table = Person . merge ( Address , left_on = [ 'PersonId' ], right_on = [ 'PersonId' ], how = 'left' ) table [ 'FirstName' , 'LastName' , 'City' , 'State' ] 176.第二高薪 sql # if there is no tie and consider null value V1: select ( select distinct salary from Employee order by salary desc limit 1 , 1
【文件预览】：
Leetcode-SQL-rewrite-using-Python--master
----README.md(35KB)