LeetCode知识点总结 - 183

最新推荐文章于 2022-10-02 15:02:13 发布

jeeeee_no

最新推荐文章于 2022-10-02 15:02:13 发布

阅读量112

点赞数

分类专栏： LeetCode 文章标签： leetcode 算法职场和发展

本文链接：https://blog.csdn.net/m0_59773145/article/details/122184084

版权

LeetCode 专栏收录该内容

417 篇文章 1 订阅

订阅专栏

该博客介绍了一个SQL查询问题，旨在从数据库中筛选出从未下单的客户。通过使用`NOT IN`操作符，可以从`customers`表中过滤出那些ID不在`orders`表中的客户记录，从而得到未下单的客户列表。

摘要由CSDN通过智能技术生成

LeetCode 183. Customers Who Never Order

考点	难度
Database	Easy

题目

Write an SQL query to report all customers who never order anything.

Return the result table in any order.

思路

用not in对customerid进行筛选。

答案

select customers.name as 'Customers'
from customers
where customers.id not in (
    select customerid from orders
);

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

jeeeee_no

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

专栏目录

LeetCode知识点总结 - 542

m0_59773145的博客

01-04

166

LeetCode 542. 01 Matrix

LeetCode知识点总结 - 1886

m0_59773145的博客

01-05

187

LeetCode 1886. Determine Whether Matrix Can Be Obtained By Rotation 考点难度 Matrix Easy 题目 Given two n x n binary matrices mat and target, return true if it is possible to make mat equal to target by rotating mat in 90-degree increments, or false o

参与评论您还未登录，请先登录后发表或查看评论

【Leetcode】183. Customers Who Never Order （Easy）

不想做菜鸟的小螃蟹

02-02

372

1.题目 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. 翻译：假设一个网站包含两个表，Customers表和Orders表

数据库 leetcode 183

weixin_42336835的博客

06-10

230

select b.name as Department,a.name as Employee,a.Salary from Employee a join Department b on a.DepartmentId=b.id and (a.salary,a.DepartmentId) in (select max(salary),DepartmentId from Employee group by DepartmentId) 经典的topn select Department, Employee,

Leetcode: 183

CHNMSCS

01-02

255

题目：思路：这道题是说找到没有order的客户，能立刻想到用到的方法是：not exists exists: 为真就返回结果集 not exists: 为真就不返回结果集代码： select 1 from table 的结果是临时得到1列 (列的值为1)，其行数为表的记录数 (行数) SELECT C.Name as Customers FROM Customers C WHERE not exists( select 1 from Orders O where C.Id

LeetCode：183. 从不订购的客户

weixin_44160044的博客

05-13

136

某网站包含两个表，Customers 表和 Orders 表。编写一个 SQL 查询，找出所有从不订购任何东西的客户。 Customers 表： ±—±------+ | Id | Name | ±—±------+ | 1 | Joe | | 2 | Henry | | 3 | Sam | | 4 | Max | ±—±------+ Orders 表： ±—±-----------+ | Id | CustomerId | ±—±-----------+ | 1 | 3

Leetcode183: Different Ways to Add Parentheses

12-05

312

Given a string of numbers and operators, return all possible results from computing all the different possible ways to group numbers and operators. The valid operators are+, - and *. Example 1 I

leetcode知识点总结-Portfolio:论文、技术博客文章、演讲和项目组合

06-30

知识点总结文件夹我创建了这个存储库来收集和总结我完成的许多项目。它主要包括我在学习期间或空闲时间所做的项目（由于迄今为止我工作的公司的隐私原因，大部分不包括工作经验）。除了这里列出的项目之外，我的 ...

LeetCode知识点总结 - 166

m0_59773145的博客

10-02

623

LeetCode 166. Fraction to Recurring Decimal

LeetCode知识点总结 - 1608

m0_59773145的博客

12-25

420

LeetCode 1608. Special Array With X Elements Greater Than or Equal X 考点难度 Sorting Easy 题目 You are given an array nums of non-negative integers. nums is considered special if there exists a number x such that there are exactly x numbers in nums t

LEETCODE database 183. Customers Who Never Order

DieHorseSpecial的博客

02-29

433

leetcode 183

leetcode183-Customers Who Never Order

爱橙子的OK绷的专栏

04-08

691

问题描述：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.Table: Customers.+----+-------+ | Id | Name

leetcode 183. Customers Who Never Order

有志者事竟成

08-08

1565

183. Customers Who Never Order Question Editorial Solution My Submissions Total Accepted: 21129Total Submissions: 64940Difficulty: Easy Suppose that a website contains

Duplicate Emails

tmac9209的博客

10-07

472

Write a SQL query to find all duplicate emails in a table named Person.+—-+———+ | Id | Email | +—-+———+ | 1 | a@b.com | | 2 | c@d.com | | 3 | a@b.com | +—-+———+ For example, your query shou

【LeetCode】183.从不订购的客户

wal1314520的博客

04-27

2942

183.从不订购的客户假设一个网站包含两个表，Customers 表和 Orders 表。编写一个SQL语句找出所有从不订购任何东西的客户。用到的表和数据SQL：Create table If Not Exists Customers (Idint, Name varchar(255)); Create table If Not Exists Orders (Id int,CustomerId i...

算法刷题19-从不订购的客户（leetcode183）

weixin_65549694的博客

05-17

498

2022.5.17 十三级全能系战魂师题目描述某网站包含两个表，Customers 表和 Orders 表。编写一个 SQL 查询，找出所有从不订购任何东西的客户。 Customers 表： +----+-------+ | Id | Name | +----+-------+ | 1 | Joe | | 2 | Henry | | 3 | Sam | | 4 | Max | +----+-------+ Orders 表： +----+------------+ | ...

LeetCode知识点总结 - 1009

m0_59773145的博客

01-23

5740

LeetCode 1009. Complement of Base 10 Integer 考点难度 Bit Manipulation Easy 题目 The complement of an integer is the integer you get when you flip all the 0’s to 1’s and all the 1’s to 0’s in its binary representation. For example, The integer 5 is “1

LeetCode知识点总结 - 1021

m0_59773145的博客

01-23

5463

LeetCode 1021. Remove Outermost Parentheses 考点难度 String Easy 题目 A valid parentheses string is either empty "", "(" + A + ")", or A + B, where A and B are valid parentheses strings, and + represents string concatenation. For example, "", "()", "(

LeetCode知识点总结 - 944

m0_59773145的博客

01-22

2248

LeetCode 944. Delete Columns to Make Sorted 考点难度 Array Easy 题目 You are given an array of n strings strs, all of the same length. The strings can be arranged such that there is one on each line, making a grid. For example, strs = ["abc", "bce", "

高效备战技术面试：leetcode苹果-coding-interview-prep-today

知识点详细说明: 1. LeetCode平台 LeetCode是一个在IT行业广泛使用的在线编程平台，主要用于帮助程序员通过解决各种难度的算法和数据结构问题来准备技术面试。它提供了丰富的编程题目库，涵盖了多个技术领域的面试...