Poslednja dva zapisa iz grupe

[ ferguson @ 05.09.2016. 15:07 ] @

Imam tabelu u sledecem formatu u ACCESS 2010

Code:

ID|Tip|AT
1|nesto|0001
2|nesto2|0001
3|nesto3|0001
...
498|nesto2|0001
499|nesto3|0001
501|neston1|0002
502|neston2|0002
503|neston3|0002
...
999|neston2|0002
1000|neston3|0002
1001|nestox1|0003
1002|nestox2|0003
1003|nestox3|0003
...
1501|nestox2|0003
1502|nestox3|0003

Meni treba da izvucem poslednja dva zapisa iz svake grupe (AT)

Code:

498|nesto2|0001
499|nesto3|0001
999|neston2|0002
1000|neston3|0002
1501|nestox2|0003
1502|nestox3|0003

[ ferguson @ 05.09.2016. 15:13 ] @

Pronasao resenje ovde
Potrebno je samo obrnuti poredjenje

Code:

select a.*
from Tablename a
where
(
   select count(*)
   from Tablename as b
   where a.group = b.group and a.id <= b.id
) <= 2