java springBoot mybatis Expected one result (or null) to be returned by selectOne(), but found: 2

Expected one result (or null) to be returned by selectOne(), but found: 2

error：

Expected one result (or null) to be returned by selectOne(), but found: 2

解释:

selectOne（）应返回一个结果（或null），但找到：2

从解释可以看出返回值大于1，而只接收了一个，解决方法 在后面加limit分页 只限制一条数据。
postgreSql
后加 limit 1 OFFSET 0

select * from table where name='aaa' limit 1 OFFSET 0

mysql
后加 limit 1

select * from table where name='aaa' limit 1 

sqlServer
查询条件前加 top 1

select top 1 * from table 

Oracle
where后加 rownum = 1

select * from  TABLES where ID>2 and rownum = 1