SELECT c_Test.*; FROM c_Test ; WHERE iSaleid in ( ; SELECT isaleid FROM (SELECT TOP 2 isaleid, PADL(TRIM(cInvoiceNo),11) AS SortOrder ; FROM c_Test ORDER BY SortOrder desc) dt1)>
CREATE CURSOR c_Test; >(iSaleid i,; >cInvoiceNo c(11),; >cDesc C(10)) > >FOR i = 1 TO 11 > INSERT INTO c_Test (iSaleid, cInvoiceNo, cDesc) VALUES (i, TRANSFORM(i), TRANSFORM(i)) >ENDFOR > >SET ANSI ON > >SELECT c_Test.*; > FROM c_Test ; > WHERE iSaleid in (SELECT TOP 2 isaleid FROM c_Test ORDER BY cInvoiceNo desc) > >SET ANSI OFF > >SELECT c_Test.*; > FROM c_Test ; > WHERE iSaleid in (SELECT TOP 2 isaleid FROM c_Test ORDER BY cInvoiceNo desc)>