Что используется вместо First на Муркоде

DimonA

Дата: 12.12.2002 16:13:27

Я хочу выполнить запрос в MS SQL который в MS Access выглядит так

SELECT [tmpObor].NOM_INVK, [tmpObor].GOD_AMORT, [tmpObor].MES_AMORT, [tmpObor].SFR_CEHA, [tmpObor].SFR_UCHA, [tmpObor].SFR_BRIG,
First([tmpObor].KOD_GRUPPA_NU) AS KOD_GRUPPA_NU, First([tmpObor].Typ_fonda) AS Typ_fonda,
First([tmpObor].KOD_VIDA_OS) AS KOD_VIDA_OS, First([tmpObor].KOD_OTRG) AS KOD_OTRG, First([tmpObor].PRVA_BUH) AS PRVA_BUH,
First([tmpObor].Ost_nach) AS Ost_nach, Sum([tmpObor].Postup) AS Postup, Sum([tmpObor].Vibit) AS Vibit, First([tmpObor].Prz_os)
AS Prz_os, First([tmpObor].Typ_oper) AS Typ_oper, First([tmpObor].Kod_psvb) AS Kod_psvb, First([tmpObor].Sum_amort) AS Sum_amort,
First([tmpObor].Sum_iznos) AS Sum_iznos, First([tmpObor].Nch_iznos) AS Nch_iznos, Sum([tmpObor].Pos_iznos) AS Pos_iznos,
Sum([tmpObor].Vib_iznos) AS Vib_iznos, First([tmpObor].Kod_vibt) AS Kod_vibt, First([tmpObor].SH_ZATRAT) AS SH_ZATRAT,
Sum([tmpObor].Nch_suma) AS Nch_suma, Sum([tmpObor].Sum_iznosa) AS Sum_iznosa, First([tmpObor].KOD_KOF) AS KOD_KOF,
First([tmpObor].SCHET) AS SCHET, First([tmpObor].Ost_nachN) AS Ost_nachN, Sum([tmpObor].PostupN) AS PostupN,
Sum([tmpObor].VibitN) AS VibitN, First([tmpObor].Sum_amortN) AS Sum_amortN, First([tmpObor].Sum_iznosN) AS Sum_iznosN,
First([tmpObor].Nch_iznosN) AS Nch_iznosN, Sum([tmpObor].Pos_iznosN) AS Pos_iznosN, Sum([tmpObor].Vib_iznosN) AS Vib_iznosN,
Sum([tmpObor].Nch_sumaN) AS Nch_sumaN, Sum([tmpObor].Sum_iznN) AS Sum_iznN, First([tmpObor].id_user) AS id_user FROM tmpObor
WHERE [tmpObor].id_user = ' + IntToStr(puser) + ' GROUP BY [tmpObor].NOM_INVK, [tmpObor].GOD_AMORT, [tmpObor].MES_AMORT,
[tmpObor].SFR_CEHA, [tmpObor].SFR_UCHA, [tmpObor].SFR_BRIG;

В MS SQL групповой операции First нет. Если кто-то знает подскажите, что можно использовать вместо First?