SQL語句怎麼寫??

Question

問題:現有一Table,表名: user,內容如下:
                員工工號(emp_no) 員工名稱(emp_nm) 部門編號(dep_no) 
                001              nm001           A
                002              nm002           A
                003              nm003           A
004              nm004           B
005              nm005           A
006              nm006           C
007              nm007           B
008              nm008           C
009              nm009           A
010              nm010           C
        想轉為如下格式顯示:
                     A         B         C
                    001        004        006
                    002        007        008
003                   010
005
009
   SQL語句怎麼寫??

Answer 1

select  (case dep_no when A then emp_no A when B then emp_no B when C then emp_no C end ) from user;

Answer 2

select * from user order by dep_no;

Answer 3

格式是這樣的！！！！！！！！！問題:現有一Table,表名: user,內容如下:
                員工工號(emp_no) 員工名稱(emp_nm) 部門編號(dep_no) 
                001              nm001           A
                002              nm002           A
                003              nm003           A
                004              nm004           B
                005              nm005           A
                006              nm006           C
                007              nm007           B
                008              nm008           C
                009              nm009           A
                010              nm010           C
        想轉為如下格式顯示:
                     A         B         C
                    001        004        006
                    002        007        008
                    003                   010
                    005
                    009
   SQL語句怎麼寫??

Answer 4

select 
case when dep_no='A' then emp_no end A,
case when dep_no='B' then emp_no end B,
case when dep_no='C' then emp_no end C
from table

Answer 5

老兄，用oracle 8，沒有case !!!

Answer 6

但有一問題，顯示格式如下：
原資料：
               員工工號(emp_no) 員工名稱(emp_nm) 部門編號(dep_no) 
                001              nm001           A
                002              nm002           A
                003              nm003           A
                004              nm004           B
                005              nm005           A
                006              nm006           C
                007              nm007           B
                008              nm008           C
                009              nm009           A
                010              nm010           C
        想轉為如下格式顯示:
                     A         B         C
                    001                
                    002                
                    003                   
                               004
                    005
                                         006
                               007
                                         008
                    009
                                         010問題：中間的空行怎麼去掉？？？？？？？？？？？？？？？？？？？？？？？？