如何比较SQL中的数据

时间:2022-08-25 21:34:32

I have an application which is taking data from questionnaires users are completing on a website and inputting this into a SQL Lite database.

我有一个应用程序,它从用户在网站上完成的问卷调查中获取数据并将其输入到SQL Lite数据库中。

I'm using Django and would like to display data of users who match closest by selecting similar answers.

我正在使用Django,并希望通过选择类似的答案来显示匹配最近的用户的数据。

How could this be done?

怎么可以这样做?

1 个解决方案

#1


1  

You can add multiple join conditions like this

您可以添加这样的多个连接条件

SELECT *
FROM <table>

INNER JOIN <same table different name>
    ON (condition1 OR condition2 OR condition3)

#1


1  

You can add multiple join conditions like this

您可以添加这样的多个连接条件

SELECT *
FROM <table>

INNER JOIN <same table different name>
    ON (condition1 OR condition2 OR condition3)