|
|
Sponsored Content
Top Forums
Programming
SQL Grouping SUM
Post 302587281 by vgersh99 on Wednesday 4th of January 2012 11:37:01 AM
|
|
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
how would I write a command line that creates a new file named stuff.txt in the current working directory which contains the number of directories in the current working directory, followed by the number of empty files in the current working directory, followed by the name of the working directory? (3 Replies)
Discussion started by: jorogon0099
3 Replies
2. Shell Programming and Scripting
Hi
i data looks like this:
student 1
Subject1 45 55
Subject2 44 55
Subject3 33 44
//
student 2
Subject1 45 55
Subject2 44 55
Subject3 33 44
i would like to sum $2, $3 (marks) and divide each entry in $2 and $3 with their respective sums and print for each student as $4 and... (2 Replies)
Discussion started by: saint2006
2 Replies
3. Shell Programming and Scripting
Hi,
I have an array of strings. Each string has 4 comma separated values. I am binding this array to a SQL where I am required to do an INSERT after grouping.
The binding is done as :
$insertADWSth->bind_param_array(1,A_CONSTANT_STRING);... (1 Reply)
Discussion started by: sinpeak
1 Replies
4. UNIX for Dummies Questions & Answers
How do you do grouping in grep? Here's how I tried it at first:
egrep 'qualit(y|ies)' /usr/share/dict/words
-bash: syntax error near unexpected token `('
I'm using GNUgrep, and I found this on their site. grep regular expression syntax
So I tried this:
egrep 'qualit\(y\|ies\)'... (2 Replies)
Discussion started by: sudon't
2 Replies
5. Shell Programming and Scripting
Hi all,
I am using following command:
perl program.pl input.txt output.txt CUTOFF 3 > groups_3.txt
containing program.pl, two files (input.txt, output.txt) and getting output in groups_3.txt:
But, I wish to have 30 files corresponding to each CUTOFF ranging from 0 to 30 using the same... (1 Reply)
Discussion started by: bioinfo
1 Replies
6. Shell Programming and Scripting
Hi Gurus,
I would like to do in a script something that is really easy in sql.
Basically, I have a file with a fomat like the following:
name1_test 501
name 1 33 510
test2 900
name1_test 300
So, I would like to group them as... (3 Replies)
Discussion started by: ocramas
3 Replies
7. Shell Programming and Scripting
awk 'FNR==NR {a; next} $NF in a' genes.txt refseq_exons.txt > output.txt
I can not figure out how to group the same name in $4 together.
Basically, all the SKI together in separate rows and all the TGFB2. Thank you :).
chr1 2160133 2161174 SKI
chr1 218518675 218520389 TGFB2... (1 Reply)
Discussion started by: cmccabe
1 Replies
8. Shell Programming and Scripting
Hello,
I would like to group/sort a file of records by a particular field and then count how many records belong in that grouping.
For example say I have the following data:
1234|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|AA
ABCD|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|AA
EFGH|"ZZZ"|"Date"|"1"|"Y"|"ABC"|""|BB... (14 Replies)
Discussion started by: Nik44
14 Replies
LEARN ABOUT DEBIAN
ogamesim
ogamesim(6) Games Manual ogamesim(6) NAME
Console Ogame Simulator SYNOPSYS
ogamesim [ -i <task.txt> ] [ -o <result.txt> ] DESCRIPTION
Tasks for simulation are consist of text files. Example of task concluding all possible units is adduced bellow. OPTIONS
-i <input file>: task file (STDIN unless defined); -o <output file>: result file (STDOUT unless defined); -s <iterations count>: 1 <= value <= N (no limits); -t <max simulation time>: (seconds) 0 <= value <= N, 0=no limits; -f <forks count>: 0 <= value <= 100. RETURN VALUES
0: if success EXAMPLES
Task concluding all possible units: attacker attack = 9 shield = 10 armory = 11 Small Cargo = 10 Large Cargo = 10 Light Fighter = 20 Heavy Fighter = 30 Cruiser = 40 Battleship = 50 Colony Ship = 60 Recycler = 70 Espionage Probe = 80 Bomber = 900 Destroyer = 110 Deathstar = 120 defender attack = 11 shield = 12 armory = 13 Rocket Launcher = 100 Light Laser = 200 Heavy Laser = 300 Gauss Cannon = 400 Ion Cannon = 500 Plasma Turret = 600 Small Shield Dome = 1 Large Shield Dome = 1 Solar Satellite = 100 metal = 123456 crystal = 56789 deut = 987654 ogamesim Dec 4, 2006 ogamesim(6)