MySQL是否“选择限制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 的 CURRENT 占用者，我需要我的查询从顶部向下选择与位置字符串匹配的第一个记录.

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 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是否“选择限制1"?有多条记录从顶部选择第一条记录?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！