Skip to content
Advertisement

selecting the first value that equals a number or letter sql php

I have a db with 6 columns: Taarij, Mispar ,Tiltan, Ale, Yaalom and Lev.
I have a query that brings me the 50 last results ordered by Mispar, that works.

select * from Hagrala order by Mispar desc limit 0,50

I want from that query result to find some data.

For example I want to find the value of the field Mispar where Ale = 7 the first time.
What I mean that 7 can and will appear several times in the column called Ale, but I am looking in which Mispar is the highest.

If in a row Mispar = 30765 and Ale = 7 and in another row Mispar = 30755 and Ale=7 also I want to receive only 30765.

Advertisement

Answer

Just use order by and limit:

select *
from Hagrala
where Ale = 7
order by Mispar desc
limit 1;
User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement