Sponsored Content
Full Discussion: SQL Grouping SUM
Top Forums Programming SQL Grouping SUM Post 302587286 by ctsgnb on Wednesday 4th of January 2012 11:49:17 AM
Old 01-04-2012
-- deleted --

(Ooops cross post)

Last edited by ctsgnb; 01-04-2012 at 12:56 PM.. Reason: (Ooops cross post)
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

grouping and sorting??

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

Print sum and relative value of the sum

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

PERL : SQL array bind issue while grouping

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

Grouping in grep

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

Grouping

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

Grouping output with sum

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

Name grouping

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

Grouping and counting

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
LXREF(1)						      General Commands Manual							  LXREF(1)

NAME
lxref - lisp cross reference program SYNOPSIS
lxref [ -N ] xref-file ... [ -a source-file ... ] DESCRIPTION
Lxref reads cross reference file(s) written by the lisp compiler liszt and prints a cross reference listing on the standard output. Liszt will create a cross reference file during compilation when it is given the -x switch. Cross reference files usually end in `.x' and conse- quently lxref will append a `.x' to the file names given if necessary. The first option to lxref is a decimal integer, N, which sets the ignorelevel. If a function is called more than ignorelevel times, the cross reference listing will just print the number of calls instead of listing each one of them. The default for ignorelevel is 50. The -a option causes lxref to put limited cross reference information in the sources named. lxref will scan the source and when it comes across a definition of a function (that is a line beginning with `(def' it will preceed that line with a list of the functions which call this function, written as a comment preceeded by `;.. ' . All existing lines beginning with `;.. ' will be removed from the file. If the source file contains a line beginning `;.-' then this will disable this annotation process from this point on until a `;.+' is seen (how- ever, lines beginning with `;.. ' will continue to be deleted). After the annoation is done, the original file `foo.l' is renamed to `#.foo.l'" and the new file with annotation is named `foo.l' AUTHOR
John Foderaro SEE ALSO
lisp(1), liszt(1) BUGS
4th Berkeley Distribution April 29, 1985 LXREF(1)
All times are GMT -4. The time now is 06:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy