- 论坛徽章:
- 0
|
高手们?请问只保留加粗的该如何做呢?
我用的
sed -e '/[a-z,A-Z]/d' 100304.txt
还是不能保留no rows select ,郁闷!
-bash-3.00$ more 100304.txt
SQL>
SQL> select distinct lacid,cellid from glc_location_msg partition(glc_location_msg_100304) where errorcode='207'
2 minus select lac,cell_id from bs_data;
0 0
8486 2953
2 rows selected.
SQL>
SQL>
SQL> select distinct vmsc from glc_location_msg partition(glc_location_msg_100304) where errorcode='746'
2 minus select vmsc from glc_vmsc_info;
8613440327
8613442547
SQL>
SQL>
SQL> select distinct substr(srcnumber,1,7)||'0000'
2 from glc_location_msg partition(glc_location_msg_100304) where errorcode='4'
3 minus select to_char(beginnumber) from GLC_MOBILE_SEG_INFO;
no rows selected
SQL>
SQL>
SQL>
SQL> |
|