写一个查询，你将打印所有居住在伦敦和纽约的人（你不能使用where子句） [英] Write a query where you will print all those people live in london, and new york (you cannot use where clause)

问题描述

我无法找到任何查询请帮助离开这里



我尝试过：



sql>从销售人员中选择城市

city ='london'和'new york';

i am unable to find any query please help out of here

What I have tried:

sql > select city from salepeople
city = 'london' and 'new york';

推荐答案

我们不做你的作业：它是设置的因为某种原因。它就是为了让你思考你被告知的事情，并试着理解它。它也在那里，以便您的导师可以识别您身体虚弱的区域，并将更多的注意力集中在补救措施上。



亲自尝试，你可能会发现它不是和你想的一样困难！

（经OriginalGriff许可使用）



你正在学习SQL，我们无法阅读文档你。

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!
(Used with permission of OriginalGriff)

You are learning SQL, we can't read the documentation for you.

你好Dinesh，



请尝试自我加入如下：

Hi Dinesh,

Please Try with Self Join Such as:

1. SELECT A.* FROM EmployeeList A 
INNER JOIN Employeelist B ON
A.EmployeeId=B.EmployeeId AND A.city IN ('london','new york')


2.SELECT A.* FROM EmployeeList A 
INNER JOIN Employeelist B ON
A.EmployeeId=B.EmployeeId AND (A.city ='london' OR A.city ='new york')

Ashish Nigam

Ashish Nigam

这篇关于写一个查询，你将打印所有居住在伦敦和纽约的人（你不能使用where子句）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！