如何获得发现之前USER_ID

Question

，所以如果我有这样的

SELECT * FROM PRIORITY ORDER BY priority_number ASC

id | user_id | priority_number 
------------------------------ 
1 | 1 |  4   
2 | 5 |  5   
3 | 2 |  6   
4 | 3 |  7   
5 | 6 |  8   
6 | 8 |  9   
7 | 7 |  10   
8 | 10 |  12   
9 | 9 |  13   
10 | 12 |  14   
11 | 13 |  15   
12 | 11 |  16   

一个数据库，然后当我搜索查询的所有结果user_id = 7然后我会拿到第一的user_id

id | user_id | priority_number 
------------------------------ 
1 | 1 |  4   
2 | 5 |  5   
3 | 2 |  6   
4 | 3 |  7   
5 | 6 |  8   
6 | 8 |  9   
7 | 7 |  10   

我到目前为止试过的东西。

SELECT * FROM PRIORITY WHERE priority_number <= 10 ORDER BY priority_number ASC但我只有user_id给出

Answer 1

在这种情况下，这将是类似的东西： SELECT * FROM PRIORITY WHERE priority_number <= (SELECT priority_number FROM PRIORITY WHERE user_id = 7) ORDER BY priority_number ASC