select distinct trid,
stid1=(select stid from aaa z where x.trid=z.trid and
z.stord = (select min(stord) from aaa f where f.trid=z.trid)
),
stid2=(select stid from aaa z where x.trid=z.trid and
z.stord = (select max(stord) from aaa f where f.trid=z.trid)
)
from aaa x

stid1=(select stid from aaa z where x.trid=z.trid and
     *
ошибка в строке 2:
ORA-00923: ключевое слово FROM не найдено там, где оно ожидалось

{ WinExecAndWait32 ******************************************** }
{ 32 bit routine that will launch an app and wait for it to     }
{ finish. Works on 32 bit & 16 bit exe's as well as .pifs       }
{ ************************************************************* }
function WinExecAndWait32(FileName: string; Visibility: integer): integer;
{ returns -1 if the Exec failed, otherwise returns the process' }
{ exit code when the process terminates.                        }
var
  zAppName: array[0..512] of char;
  zCurDir : array[0..255] of char;
  WorkDir : string;
  StartupInfo: TStartupInfo;
  ProcessInfo: TProcessInformation;
    CardinalResult: cardinal;

begin
  StrPCopy(zAppName, FileName);
  GetDir(0, WorkDir);
  StrPCopy(zCurDir, WorkDir);
  FillChar(StartupInfo, Sizeof(StartupInfo), #0);
  StartupInfo.cb := Sizeof(StartupInfo);
  StartupInfo.dwFlags := STARTF_USESHOWWINDOW;
  StartupInfo.wShowWindow := Visibility;
  if not CreateProcess(nil,
                       zAppName, { pointer to command line string }
                       nil, { pointer to process security attributes }
                       nil, { pointer to thread security attributes }
                       false, { handle inheritance flag }
                       CREATE_NEW_CONSOLE or { creation flags }
                       NORMAL_PRIORITY_CLASS,
                       nil, { pointer to new environment block }
                       nil, { pointer to current directory name }
                       StartupInfo, { pointer to STARTUPINFO }
                       ProcessInfo) then { pointer to PROCESS_INF }
    Result := -1
  else
    begin
      result:=WaitforSingleObject(ProcessInfo.hProcess, 1000000);
        GetExitCodeProcess(ProcessInfo.hProcess, CardinalResult);
      CloseHandle(ProcessInfo.hProcess);
      CloseHandle(ProcessInfo.hThread);
    end;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
  Form1.Visible:= False;
  try
    if WinExecAndWait32('calc.exe', 0) <> 0 then
      ShowMessage('бла-бла-бла');
  finally
    Form1.Visible:= True;
  end;
end;