Code: |
Name Department -------------- ----------------- Asim Khan Edison Peter Husum Edison Bryan Brilivan Prof Andy Boey Prof Niels Lauge IT Massemarked Peter Reetz Topdanmark O/P - Edison Prof IT Massemarked Topdanmark ------------ ----------------- ------------------- -------------- Asim Khan Peter Husum Bryan Brilivan Andy Boey Niels Lauge Peter Reetz |
Code: |
SELECT NAME AS EDISON ,CHAR(' ',30) AS PROF ,CHAR(' ',30) AS IT_MASSEMARKED ,CHAR(' ',30) AS TOPDANMARK FROM EMPLDEPT WHERE DEPARTMENT = 'EDISON' UNION ALL SELECT CHAR(' ',30) AS EDISON ,NAME AS PROF ,CHAR(' ',30) AS IT_MASSEMARKED ,CHAR(' ',30) AS TOPDANMARK FROM EMPLDEPT WHERE DEPARTMENT = 'PROF' UNION ALL SELECT CHAR(' ',30) AS EDISON ,CHAR(' ',30) AS PROF ,NAME AS IT_MASSEMARKED ,CHAR(' ',30) AS TOPDANMARK FROM EMPLDEPT WHERE DEPARTMENT = 'IT MASSEMARKED' UNION ALL SELECT CHAR(' ',30) AS EDISON ,CHAR(' ',30) AS PROF ,CHAR(' ',30) AS IT_MASSEMARKED ,NAME AS TOPDANMARK FROM EMPLDEPT WHERE DEPARTMENT = 'TOPDANMARK' ; |
output generated using printer-friendly topic mod. All times are GMT - 5 Hours