How can like be selected with multiple values in SQL?

 If you want to select SQL-like multiple values, I can guess that you want a row dedicated to employee_id (emp1%) and another row dedicated to employee_id (emp3%). You can follow the following command: 

(SELECT top 1 employee_id, employee_ident, utc_dt, rx_dt

FROM employee

)AS t1

UNION ALL

SELECT t2.*

FROM 

)AS t2;

You can use UNION ALL because the legs in the union can be disjointed. It can be a performance advantage. Also, since SQL-server 2008 allows undow functions, for example, row_number(), you can also run the following query.