Shell Programming and Scripting

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

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

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

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

Thank you very much for the solution.

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

Thanks

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