免费下载:IBM® DB2® Express-C 9.7.2 免费版 或者 DB2® 9.7 for Linux®, UNIX®, and Windows® 试用版 |
下载更多的 IBM 软件试用版,并加入 IBM 软件下载与技术交流群组,参与在线交流。 |
COL[UMN] [column_name-1 [CLE[AR] | FOR[MAT] format_spec | HEA[DING] heading_text | JUSTIFY [ LEFT | RIGHT | CENTER ] | WRAPPED | TRUNCATED | FOLD_AFTER | FOLD_BEFORE | 过草地 NEWLINE | LIKE <column_name-2> | NULL <ur-text> | PRINT|NOPRINT | NEW_VALUE variable-name | OLD_VALUE variable-name | ALIAS alias-name | ON | ]] |
SQL>column salary format 99999.99 怎么开发大脑SQL>column lastname format A6 SQL>firstnme, lastname, salary from employee ; FIRSTNME LASTNA SALARY ------------ ------ ----------- CHRISTINE HAAS >### MICHAEL THOMPS 94250.00 ON SALLY KWAN 98250.00 JOHN GEYER 80175.00 IRVING STERN 72250.00 EVA PULASK 96170.00 I EILEEN HENDER 89750.00 SON THEODORE SPENSE 86150.00 R VINCENZO LUCCHE 66500.00 SSI SEAN O'CONN 49250.00 ELL |
SQL>column firstnme format A8 wrapped SQL>column lastname format A8 truncated SQL>lect firstnme, lastname from emp; FIRSTNME LASTNAME -------- -------- CHRISTIN HAAS E MICHAEL THOMPSON SALLY KWAN JOHN GEYER IRVING STERN EVA PULASKI EILEEN THEODORE SPENSER SEAN DELORES QUINTANA HEATHER NICHOLLS BRUCE ADAMSON ELIZABET PIANKA H I 光子嫩肤的功效MARILYN SCOUTTEN |
SQL>column firstnme justify left许和平 SQL>column midinit justify center SQL>column salary justify right SQL>lect firstnme, midinit, salary from employee; FIRSTNME MIDINIT SALARY ------------ ------- ----------- CHRISTINE I 152750.00 MICHAEL L 94250.00 SALLY A 98250.00 JOHN B 80175.00 IRVING F 72250.00 EVA D 96170.00 EILEEN W 89750.00 THEODORE Q 86150.00 VINCENZO G 66500.00 SEAN 49250.00 DELORES M 73800.00 HEATHER A 68420.00 BRUCE 55280.00 ELIZABETH R 62250.00 MASATOSHI J 44680.00 MARILYN S 51340.00 JAMES H 50450.00 DAVID 57740.00 WILLIAM T 68270.00 JENNIFER K 49840.00 JAMES J 42180.00 SALVATORE M 48760.00 |
本文发布于:2023-06-07 23:40:10,感谢您对本站的认可!
本文链接:https://www.wtabcd.cn/fanwen/fan/82/897887.html
版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。
留言与评论(共有 0 条评论) |