René's URL Explorer Experiment


Title: BestNote/docs/notes/Leetcode-Database 题解.md at master · bensonchen/BestNote · GitHub

Open Graph Title: BestNote/docs/notes/Leetcode-Database 题解.md at master · bensonchen/BestNote

X Title: BestNote/docs/notes/Leetcode-Database 题解.md at master · bensonchen/BestNote

Description: :punch: 持续更新，Java Android 近几年最全面的技术点以及面试题 供自己学习使用. Contribute to bensonchen/BestNote development by creating an account on GitHub.

Open Graph Description: :punch: 持续更新，Java Android 近几年最全面的技术点以及面试题 供自己学习使用. Contribute to bensonchen/BestNote development by creating an account on GitHub.

X Description: :punch: 持续更新，Java Android 近几年最全面的技术点以及面试题 供自己学习使用. Contribute to bensonchen/BestNote development by creating an account on GitHub.

Opengraph URL: https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository/blob/*name(/*path)
route-controllerblob
route-actionshow
fetch-noncev2:c7354e66-e053-5a8b-7583-11d43e53f305
current-catalog-service-hashf3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id8B60:241082:26F9B59:3445B2A:6A655276
html-safe-noncee7d3db6ff30b64e6f66c0eec3f5a485253864deb1dd9eedcb878f644c8a3fcba
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI4QjYwOjI0MTA4MjoyNkY5QjU5OjM0NDVCMkE6NkE2NTUyNzYiLCJ2aXNpdG9yX2lkIjoiNTQ4ODEwMjgxMzExMjU1NDEwMiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac79ca8ead246dc60411149458ea193a26db1a5091bcdc71acf79b569a101d00de
hovercard-subject-tagrepository:189364533
github-keyboard-shortcutsrepository,source-code,file-tree,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///blob/show
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md
twitter:imagehttps://opengraph.githubassets.com/c1e2517d46ab92d5e7bba561677fa7506721850bc42b0461012808af3a800433/bensonchen/BestNote
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/c1e2517d46ab92d5e7bba561677fa7506721850bc42b0461012808af3a800433/bensonchen/BestNote
og:image:alt:punch: 持续更新，Java Android 近几年最全面的技术点以及面试题 供自己学习使用. Contribute to bensonchen/BestNote development by creating an account on GitHub.
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None52c76df668885aaff23b50bdca1fa1ea44ac9c1553e888ebc70ff1e4daa4625b
turbo-cache-controlno-cache
go-importgithub.com/bensonchen/BestNote git https://github.com/bensonchen/BestNote.git
octolytics-dimension-user_id1281739
octolytics-dimension-user_loginbensonchen
octolytics-dimension-repository_id189364533
octolytics-dimension-repository_nwobensonchen/BestNote
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forktrue
octolytics-dimension-repository_parent_id180915066
octolytics-dimension-repository_parent_nwopengMaster/BestNote
octolytics-dimension-repository_network_root_id180915066
octolytics-dimension-repository_network_root_nwopengMaster/BestNote
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release309153364422b3c499922d1a2a6404910a58ed8e
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fbensonchen%2FBestNote%2Fblob%2Fmaster%2Fdocs%2Fnotes%2FLeetcode-Database%2520%25E9%25A2%2598%25E8%25A7%25A3.md
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub Copilot appDirect agents from issue to mergehttps://github.com/features/ai/github-app
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
Code QualityEnforce quality at mergehttps://github.com/features/code-quality
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
View all resourceshttps://github.com/resources
GitHub SponsorsFund open source developershttps://github.com/open-source/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/open-source/accelerator
GitHub Starshttps://stars.github.com
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fbensonchen%2FBestNote%2Fblob%2Fmaster%2Fdocs%2Fnotes%2FLeetcode-Database%2520%25E9%25A2%2598%25E8%25A7%25A3.md
Sign up https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fblob%2Fshow&source=header-repo&source_repo=bensonchen%2FBestNote
Reloadhttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md
Reloadhttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md
Reloadhttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md
bensonchen https://github.com/bensonchen
BestNotehttps://github.com/bensonchen/BestNote
pengMaster/BestNotehttps://github.com/pengMaster/BestNote
Notifications https://github.com/login?return_to=%2Fbensonchen%2FBestNote
Fork 0 https://github.com/login?return_to=%2Fbensonchen%2FBestNote
Star 0 https://github.com/login?return_to=%2Fbensonchen%2FBestNote
Code https://github.com/bensonchen/BestNote
Pull requests 0 https://github.com/bensonchen/BestNote/pulls
Actions https://github.com/bensonchen/BestNote/actions
Projects https://github.com/bensonchen/BestNote/projects
Security and quality 0 https://github.com/bensonchen/BestNote/security
Insights https://github.com/bensonchen/BestNote/pulse
Code https://github.com/bensonchen/BestNote
Pull requests https://github.com/bensonchen/BestNote/pulls
Actions https://github.com/bensonchen/BestNote/actions
Projects https://github.com/bensonchen/BestNote/projects
Security and quality https://github.com/bensonchen/BestNote/security
Insights https://github.com/bensonchen/BestNote/pulse
https://github.com/bensonchen/BestNote
BestNotehttps://github.com/bensonchen/BestNote/tree/master
docshttps://github.com/bensonchen/BestNote/tree/master/docs
noteshttps://github.com/bensonchen/BestNote/tree/master/docs/notes
Historyhttps://github.com/bensonchen/BestNote/commits/master/docs/notes/Leetcode-Database%20%E9%A2%98%E8%A7%A3.md
https://github.com/bensonchen/BestNote/commits/master/docs/notes/Leetcode-Database%20%E9%A2%98%E8%A7%A3.md
BestNotehttps://github.com/bensonchen/BestNote/tree/master
docshttps://github.com/bensonchen/BestNote/tree/master/docs
noteshttps://github.com/bensonchen/BestNote/tree/master/docs/notes
Rawhttps://github.com/bensonchen/BestNote/raw/refs/heads/master/docs/notes/Leetcode-Database%20%E9%A2%98%E8%A7%A3.md
595. Big Countrieshttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#595-big-countries
627. Swap Salaryhttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#627-swap-salary
620. Not Boring Movieshttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#620-not-boring-movies
596. Classes More Than 5 Studentshttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#596-classes-more-than-5-students
182. Duplicate Emailshttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#182-duplicate-emails
196. Delete Duplicate Emailshttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#196-delete-duplicate-emails
175. Combine Two Tableshttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#175-combine-two-tables
181. Employees Earning More Than Their Managershttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#181-employees-earning-more-than-their-managers
183. Customers Who Never Orderhttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#183-customers-who-never-order
184. Department Highest Salaryhttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#184-department-highest-salary
176. Second Highest Salaryhttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#176-second-highest-salary
177. Nth Highest Salaryhttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#177-nth-highest-salary
178. Rank Scoreshttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#178-rank-scores
180. Consecutive Numbershttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#180-consecutive-numbers
626. Exchange Seatshttps://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#626-exchange-seats
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#595-big-countries
https://leetcode.com/problems/big-countries/description/https://leetcode.com/problems/big-countries/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#627-swap-salary
https://leetcode.com/problems/swap-salary/description/https://leetcode.com/problems/swap-salary/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-1
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-1
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-1
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#620-not-boring-movies
https://leetcode.com/problems/not-boring-movies/description/https://leetcode.com/problems/not-boring-movies/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-2
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-2
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-2
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#596-classes-more-than-5-students
https://leetcode.com/problems/classes-more-than-5-students/description/https://leetcode.com/problems/classes-more-than-5-students/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-3
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-3
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-3
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#182-duplicate-emails
https://leetcode.com/problems/duplicate-emails/description/https://leetcode.com/problems/duplicate-emails/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-4
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-4
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-4
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#196-delete-duplicate-emails
https://leetcode.com/problems/delete-duplicate-emails/description/https://leetcode.com/problems/delete-duplicate-emails/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-5
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-5
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-5
pMySQL Error 1093 - Can't specify target table for update in FROM clausehttps://stackoverflow.com/questions/45494/mysql-error-1093-cant-specify-target-table-for-update-in-from-clause
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#175-combine-two-tables
https://leetcode.com/problems/combine-two-tables/description/https://leetcode.com/problems/combine-two-tables/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-6
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-6
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-6
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#181-employees-earning-more-than-their-managers
https://leetcode.com/problems/employees-earning-more-than-their-managers/description/https://leetcode.com/problems/employees-earning-more-than-their-managers/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-7
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-7
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-7
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#183-customers-who-never-order
https://leetcode.com/problems/customers-who-never-order/description/https://leetcode.com/problems/customers-who-never-order/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-8
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-8
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-8
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#184-department-highest-salary
https://leetcode.com/problems/department-highest-salary/description/https://leetcode.com/problems/department-highest-salary/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-9
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-9
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-9
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#176-second-highest-salary
https://leetcode.com/problems/second-highest-salary/description/https://leetcode.com/problems/second-highest-salary/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-10
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-10
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-10
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#177-nth-highest-salary
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-11
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-11
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-11
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#178-rank-scores
https://leetcode.com/problems/rank-scores/description/https://leetcode.com/problems/rank-scores/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-12
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-12
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-12
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#180-consecutive-numbers
https://leetcode.com/problems/consecutive-numbers/description/https://leetcode.com/problems/consecutive-numbers/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-13
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-13
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-13
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#626-exchange-seats
https://leetcode.com/problems/exchange-seats/description/https://leetcode.com/problems/exchange-seats/description/
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#description-14
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#sql-schema-14
https://github.com/bensonchen/BestNote/blob/master/docs/notes/Leetcode-Database 题解.md#solution-14
https://camo.githubusercontent.com/1bd8d259e359beb33e23bed56ba6fb64b25303c01e6ab8be90d63d94559a2c3d/68747470733a2f2f6379632d313235363130393739362e636f732e61702d6775616e677a686f752e6d7971636c6f75642e636f6d2f2545352538352541432545342542432539372545352538462542372e6a7067
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.