MySQL是否会"SELECT LIMIT 1"有多个记录，从顶部选择第一个记录? [英] Does MySQL "SELECT LIMIT 1" with multiple records select first record from the top?

问题描述

我已经搜索了很多，但找不到这个问题的答案，我可能是用错误的方式提出的.

I've searched and searched and can't find an answer to this question, I'm probably asking it in the wrong way.

我正在查询员工数据库.

I am querying an employee database.

我需要根据职位ID获取详细信息，但是该职位ID可能会有多条记录，因为该组织有长期工作的员工和临时员工对同一职位采取行动.

I need to get details based on a position id, however there could be multiple records for that position id as this organisation has permanent employees and temporary employees that act against the same position.

因此，为了获取当前位置ID的居住者，我需要查询从TOP DOWN中选择与位置字符串匹配的FIRST记录.

So, in order to get the CURRENT occupant of the position id, I need my query to SELECT the FIRST record that matches the position string, from the the TOP DOWN.

这会从顶部选择第一个匹配的记录吗?

will this select the first matched record from the top?

SELECT * WHERE `position_id`="00000000" LIMIT 1;

先谢谢了.

推荐答案

您需要一个ORDER BY子句来定义表中各个记录之间的顺序.如果不使用ORDER BY，则可以假定记录之间没有固定的顺序，并且每次执行查询时都可以得到新的顺序.

You need an ORDER BY clause to define the ordering between the individual records your table. If you do not use ORDER BY you can assume no fixed order between the records, and you could get a new order each time you executed the query.

这篇关于MySQL是否会"SELECT LIMIT 1"有多个记录，从顶部选择第一个记录?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！