mysql queries..

SELECT DISTINCT ns
FROM (

SELECT ns, MAX( `sloj` ) m
FROM `w2`
GROUP BY ns
)foo
WHERE m <2041
ORDER BY `foo`.`ns` ASC

and another

select id, max(vērtība) m from tabula group by id having m <= 5