Subject sum(field) with subselect
Author Roland Turcan

I need sum two rows in table, but those rows is returned from

select sum(Field) from Table where ID in (select first 2 ID from Table);

This statement tot up all rows from Table and not only two rows that
were returned from subselect.

This statement return two rows with 63, 64 value
select first 2 jedin from nastavenia;

And this tot up, and result is OK.
select sum(jedin) from nastavenia where jedin in (63,64);

Why does't work.

Best regards, TRoland