10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
select to_char(cre_on, 'ddmm hh24'), proc_flg, count(*) from ib_prd.tb_ibmh_msg_log where message_type = 'DECHECK_OUT'
and cre_on > to_date('27/08/2016 00:00:00', 'dd/MM/yyyy hh24:mi:ss')
group by to_char(cre_on, 'ddmm hh24'), proc_flg
order by 1;
1) what does order by 1 means
2) group by... (1 Reply)
Discussion started by: houmingc
1 Replies
2. UNIX for Dummies Questions & Answers
Hi ,
I have around 1000000 odd lines in a file in random order.
The file looks like this:
>string102
>string10437183
>string514
>string10435771
>string10437259
>string1049931
>string1342
I want to arrange it in increasing order:
>string102
>string514
>string1342... (3 Replies)
Discussion started by: qwerty193
3 Replies
3. Shell Programming and Scripting
Hi guys,
I have a script in which it simply do a grep of strings for the var/adm/messages file:
NEWDATE=`TZ=GMT+1 date +%b" "%d" "%H`
getalarm1=`grep "sent to primary BE" /var/adm/messages* | grep "$NEWDATE" | wc -l`
getalarm2=`grep "CC-Request-Type 3 received in state Idle"... (5 Replies)
Discussion started by: matcam79
5 Replies
4. Shell Programming and Scripting
Hi,
I was trying to have an output as below :
1 | 2 | 3
aaa | bbb | ccc
| ccc
| ccc
... (2 Replies)
Discussion started by: scottralf
2 Replies
5. Ubuntu
Hi I have Ubuntu 10.10 installed. I want to change boot order.
Can anyone tell where is menu.lst file located. I searched it but didn't get it. Please tell me what file I need to edit for same? (3 Replies)
Discussion started by: nixhead
3 Replies
6. Shell Programming and Scripting
Good evening
I have a file as below and want to change the order, as in the second column, sed awk Pearl
Thanks
aaaaaaaaaa
bbbbbbbbb
cccccccc
aaaaaaaaaa
bbbbbbbbb
cccccccc
aaaaaaaaaa
cccccccc
bbbbbbbbb
aaaaaaaaaa
cccccccc
bbbbbbbbb (8 Replies)
Discussion started by: Novice-
8 Replies
7. Shell Programming and Scripting
I have columnar data in arrays perl, Example -
@a = (1,2,3);
@array1 = (A,B,C);
@array2 = (D,E,F);
@array3 = (I,R,T);
I want the data to be formatted and printed as
1 A D I
2 B E F
3 C F T
and so on... (8 Replies)
Discussion started by: dinjo_jo
8 Replies
8. Shell Programming and Scripting
in csh
set x = "/home/usr/dir1/file1"
if i do:
echo $x | awk -F\/ '{print $NF}'
will result to:
"file1"
how do i invert the output to:
"/home/usr/dir1"
:confused: (2 Replies)
Discussion started by: jehrome_rando
2 Replies
9. UNIX for Dummies Questions & Answers
How do you sort text in order using sed? :confused:
For example
01 B D A C
to 01 ABCD (3 Replies)
Discussion started by: evoGage
3 Replies
10. AIX
Anyone know where you can purchase a 5.1 cd set? IBM no longer ships this out and do not have a set. I have a burned copy, but would be nice to have the originals. I'd like to send my copies offsite for DR once i get an original set.
Thanks! (2 Replies)
Discussion started by: slacker
2 Replies