Cardiothoracic Intensive Care Unit
Cardiothoracic Intensive Care Unit
SELECT * FROM doctors where facility is not NULL And IsDeleted = '0' And facility like '%Cardiothoracic Intensive Care Unit%' ORDER BY empty,priority desc , dname asc;