select emp_no ,emp_name ,dept , isnull(convert(char(10),birthday,120),'日期不詳') birthday from employee order by dept --2、查找與喻自強(qiáng)在同一個(gè)單位的員工姓名、性別、部門(mén)和職稱 select emp_no,emp_name,dept,title from employee where emp_name<>'喻自強(qiáng)' and dept in ...
www.dbjr.com.cn/article/52...htm 2025-6-9