Ravnica - 5 days ago 6

MySQL Question

I am trying to get .1 above the min for column X sorted by Y in A

What I have so far is:

Select MIN(X), Y

From A

Where MIN(X) > (Min(x)+.1) <--- (if only computers did what i wanted them to not what i asked them to)

Group by Y

Answer

Is this what you want?

```
select x, y
from a
where x > (select min(x) + 0.1 from a);
```

Source (Stackoverflow)

Comments