SELECT  "Result Date", "Result", "Test","Group",RESULT_ID FROM ( 
        SELECT TOP 10 * FROM ( 
                        SELECT TOP 10 RESULTS_DATE_TIME AS "Result Date"  ,RESULT as "Result",TEST_NAME as "Test", RESULTS_DATE_TIME as ENC_DATE,RESULT_ID,LAB_GROUP_NAME as "Group"  FROM ( 
                                    SELECT RESULTS_DATE_TIME,TEST_NAME,cast(RESULTS as varchar(4000)) as RESULT,LAB_GROUP_NAME,RESULT_ID from EMRVWNUMLABRESULTS NLR  
                                    INNER JOIN EMRENCOUNTERDETAILS ED ON ED.PARENT_ENCOUNTER_ID = NLR.PARENT_ENCOUNTER_ID  where ED.IS_SAVE_FOR_LATER IN (0,4) AND  NLR.PATIENT_ID='210330' 
                                    UNION 
                                    SELECT RESULTS_DATE_TIME,TEST_NAME,cast(RESULTS as varchar(4000)) as RESULT,LAB_GROUP_NAME,RESULT_ID from EMRVWTextualLabResults NLR  
                                    INNER JOIN EMRENCOUNTERDETAILS ED ON ED.PARENT_ENCOUNTER_ID = NLR.PARENT_ENCOUNTER_ID  where ED.IS_SAVE_FOR_LATER IN (0,4)  AND NLR.PATIENT_ID='210330' 
                                   UNION 
                                   SELECT RESULTS_DATE_TIME,TEST_NAME,RESULTS ,LAB_GROUP_NAME,RESULT_ID from EMRVWTextualLabResults where  PATIENT_ID='210330' AND PARENT_ENCOUNTER_ID IS NULL  
                                   UNION 
                                   SELECT RESULTS_DATE_TIME,TEST_NAME,RESULTS ,LAB_GROUP_NAME,RESULT_ID from EMRVWNUMLABRESULTS where  PATIENT_ID='210330' AND PARENT_ENCOUNTER_ID IS NULL   
                        )TEMP1 
                                    ORDER BY RESULT_ID ASC  
            )tbl1 ORDER BY  RESULT_ID DESC  
)tbl2 ORDER BY  RESULT_ID ASC