skus takto:
create view v_docasne
as
select key_id, max(tstamp) tstamp from tabulka group by status;
select t.id, t.key_id, t.tstamp, t.status
from tabulka t
inner join v_docasne v on v.key_id = t.key_id and v.tstamp = t.tstamp
where t.status = 1;
poradna.net
Neregistrovaný Přihlásit Registrovat