MAIN Step1 Dowhile Select EMPLID SELECT EM PUD FROM ABC Peop

MAIN Step1 Dowhile %Select( EMPLID) SELECT EM PUD FROM ABC PeopleCode SQLExec(\"SELECT COUNT(*)FROM ABC\", &Count;); MessageBox(0, \"\", 0, 0, \"No of Rows in ABC Table: \" | &Count;); MessageBox(0, \"\", 0, 0, \"Employee ID in State Record: \" | CNU_AET.EMPLID.Value); SQL DELETE FROM ABC WHERE EMPLID IN ( SELECT TOP 5 EMPLID FROM ABC ORDER BY EMPLID DESC)

Solution

No of Rows in ABC Table: 10

Employee ID in State Record: AA

No of Rows in ABC Table: 5

Employee ID in State Record: AA