sql - Make union of table appear in order they are applied -

i have written sql server query returns union of few select statements. query returns data expect.

but 1 unexpected thing doing is sorting data in alphabetical order. however, want data of first table should appear on top , data of second table should appear second , on.

can me this?

select employeename employeetable employeename 'vik%' union select employeename employeetable employeename '% vik%' union select employeename employeetable employeename '%vik%' ,                                              employeename not 'vik%' ,                                              employeename not '% vik%' 

add column table sequence

select employeename, 1 my_order employeetable employeename 'vik%' union select employeename, 2 employeetable employeename '% vik%' union select employeename, 3 employeetable employeename '%vik%' , employeename not 'vik%' , employeename not '% vik%' order my_order asc, empleemployeename asc;