# IncorrectResultSizeDataAccessException: query did not return a unique result: 2

**Code:** `NonUniqueResultException` · **Category:** Java · **Seen on:** Java

A query expected one row but found several.

## Meaning

Spring Data repository methods returning a single entity/Optional throw when multiple rows match. The data or the query assumption is wrong.

## Common causes

- Duplicate data where uniqueness was assumed
- findBy... returning single instead of List
- Missing unique constraint

## Quick fix

1. Return a List and handle duplicates
2. Add a unique constraint
3. Use findFirstBy… with ordering when you want one

## Detailed fix by platform

### Java

1. `Optional<User> findFirstByEmailOrderByIdDesc(String email);`

## How to diagnose

1. **Query** — Which method?
2. **Data** — Why several rows?

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/java/incorrectresultsizedataaccessexception)
