Achieving group by logic via Unix

Shell Programming and Scripting
1

HI friends,

select count(*),country_code from employees_table group by country_code having com_country_code in ("US","UK")

CAn we have an equivalent command in Unix to achieve this

Thanks in advance
Suresh

2

What is the purpose and what are you trying to achieve? Could you be a little more clear on what you need?

3

For Eg:
File
------
US|A
US|B
US|C
UK|1
UK|2

awk 'BEGIN { FS=OFS=SUBSEP="|"}{arr[$1]++ }END {for (i in arr) print i,arr[i]}' File

awk 'BEGIN { FS=OFS=SUBSEP="|"}{arr[$1,$2]++ }END {for (i in arr) print i,arr[i]}' File

regards,
cskumar

4

Hi Guy`s I`m a newbie to Unix and I`m starting to love it

I got stuck donig backups of tar files to tape

I use this to find all tar files
find . -name '*.tar.*' > output
in output there would be n of file eg. 6
the size output is 156 but tar files are:
9.3M Jul 18 09:48 arch_done_032007.tar.gz
25M Jul 18 09:53 arch_done_042007.tar.gz
67M Jul 18 10:01 arch_done_052007.tar.gz
192M Jul 18 10:27 arch_done_062007.tar.gz
291M Aug 2 11:05 arch_done_072007.tar.gz
544M Sep 3 12:05 arch_done_082007.tar.gz
I then tar output to tape using this command
tar -cvf /dev/rmt/0 output
response is
a 2.0K Sep 3 18:47 output

can you please help me on this matter

thanks donovan

5

Thank you very much for the solution.

I would appreciate more solutions in this regard ..if any

Thanks

6

You are not going about his the right way - I guess your newness to Unix is to blame.
Your find command will simply create a file called output with the names of the files found in it. your 'tar -cvf /dev/rmt/0 output' command will - if successful - just write the file output to tape - not the tar files.
If you want ot write the gzipped (.gz) files to tape then you have to include the names in the tar command - EG tar -cvf /dev/rmt/0 abc.tar.gz
If you want to exptract te contents of the tar.gz file you will have to 'gunzip' it first to get a tar file and then extract with tar -xvf <tar file name>

Start a thread with the 'New Thread' button at the top of the forum page