Sponsored Content
Full Discussion: Group by in UNIX
Top Forums Shell Programming and Scripting Group by in UNIX Post 302938657 by zozoo on Wednesday 18th of March 2015 09:08:38 AM
Old 03-18-2015
Quote:
Originally Posted by RudiC
Show us your attempts. What stops you from printing the lines with respective groups' max?
Code:
have tried below

$ cat sample
xxx,1,100
yyy,2,,200
zzz,1,3000
eeee,1,200
ttttt,2,500
zzz,2,123
xyxy,3,1000
$ awk -F, '{if (a[$2]< $3)a[$2]=$3;}END{for(i in a){print i,a[i];}}' sample
1 3000
2 500
3 1000

I also want to print name of each entity with max value along with dep and sal

---------- Post updated at 06:38 PM ---------- Previous update was at 06:29 PM ----------

if have to to same thing in sql it would be and data isin table say temp_tbl

Code:
select name,dep,sal from temp_tbl where(dep,sal) in ( select dep,max(sal)from temp_tbl group by dep)

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how to define permission of unix group

While logged on as root, I created a user 'usera' I also created a group called 'groupa' I need to modify the permission of the user i created to not have root privileges. I also need to change groupa to be in 'others' please help! thanks, nieves (3 Replies)
Discussion started by: mncapara
3 Replies

2. UNIX for Dummies Questions & Answers

listing members of a unix group

I know there is a "groups" command to list the groups a user belongs to, but how about the opposite? Is there a standard command to find out which users belong to a particular group? (2 Replies)
Discussion started by: ovaska
2 Replies

3. Solaris

unix group file limitation

Does anyone know how to get around the unix group file limitation whereby you have a limit of 1024 characters when adding users to a unix group? (3 Replies)
Discussion started by: asmillie
3 Replies

4. Shell Programming and Scripting

Achieving group by logic via Unix

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 (5 Replies)
Discussion started by: sureshg_sampat
5 Replies

5. Shell Programming and Scripting

create group in unix

Hi, I want to create group in unix. what is the command? how to create a group and add a user into that group? Thanks in advance (2 Replies)
Discussion started by: senthil_is
2 Replies

6. UNIX for Dummies Questions & Answers

Portland UNIX student group

In CS140 .... I am having a very hard time with lab 4. I am wondering if we could put together a study group in portland. This could help all of us. Post here and I will PM you my # and we can set it up over the phone. (0 Replies)
Discussion started by: aeamacman
0 Replies

7. Shell Programming and Scripting

Group By in Unix

Hi, I have file with Header Data and trailer records Head|currentdate|EOF Data|AAA|BBB|CCC|DDD|EEE|Source1 Data|AAA|BBB|CCC|DDD|EEE|Source1 Data|AAA|BBB|CCC|DDD|EEE|Source2 Data|AAA|BBB|CCC|DDD|EEE|Source2 Data|AAA|BBB|CCC|DDD|EEE|Source2 End|rec|EOF Now I need the count of only... (3 Replies)
Discussion started by: magesh_bala
3 Replies

8. Cybersecurity

UNIX group id

How to add a user to the existing user account of a solarise server? In our solarise server we hav a acc in the name telecom ,now how to add a new user to teleco acc so that he can login in to server through telecom acc. Thanks to help (4 Replies)
Discussion started by: kkalyan
4 Replies

9. UNIX for Advanced & Expert Users

Adding UNIX user to a group

Hi, I am new to unix. I am facing access permission issue I want to access path /app/compress from a user "test" but getting permission denied error This path exist in "Main" user So after some googling i came to know we need to add "test" user in "main" group so path /app/compress ... (7 Replies)
Discussion started by: sv0081493
7 Replies

10. Shell Programming and Scripting

To group records in the file in UNIX

Hi All, I am using RHEL 6.9. I got a requirement to group the records in a file.The file content as shown below. #### FAILED JOBS IN XXX ##### 1> ABCD failed in the project XXX 2> HJK Job is in compiled state in the project XXX 3> ILKD failed in the project XXX 4> DFG failed in the... (5 Replies)
Discussion started by: ginrkf
5 Replies
DEPMOD(8)							      depmod								 DEPMOD(8)

NAME
depmod - Generate modules.dep and map files. SYNOPSIS
depmod [-b basedir] [-e] [-E Module.symvers] [-F System.map] [-n] [-v] [-A] [-P prefix] [-w] [version] depmod [-e] [-E Module.symvers] [-F System.map] [-m] [-n] [-v] [-P prefix] [-w] [version] [filename...] DESCRIPTION
Linux kernel modules can provide services (called "symbols") for other modules to use (using one of the EXPORT_SYMBOL variants in the code). If a second module uses this symbol, that second module clearly depends on the first module. These dependencies can get quite complex. depmod creates a list of module dependencies by reading each module under /lib/modules/version and determining what symbols it exports and what symbols it needs. By default, this list is written to modules.dep, and a binary hashed version named modules.dep.bin, in the same directory. If filenames are given on the command line, only those modules are examined (which is rarely useful unless all modules are listed). depmod also creates a list of symbols provided by modules in the file named modules.symbols and its binary hashed version, modules.symbols.bin. Finally, depmod will output a file named modules.devname if modules supply special device names (devname) that should be populated in /dev on boot (by a utility such as udev). If a version is provided, then that kernel version's module directory is used rather than the current kernel version (as returned by uname -r). OPTIONS
-a, --all Probe all modules. This option is enabled by default if no file names are given in the command-line. -A, --quick This option scans to see if any modules are newer than the modules.dep file before any work is done: if not, it silently exits rather than regenerating the files. -b basedir, --basedir basedir If your modules are not currently in the (normal) directory /lib/modules/version, but in a staging area, you can specify a basedir which is prepended to the directory name. This basedir is stripped from the resulting modules.dep file, so it is ready to be moved into the normal location. Use this option if you are a distribution vendor who needs to pre-generate the meta-data files rather than running depmod again later. -C, --config file or directory This option overrides the default configuration directory at /etc/depmod.d/. -e, --errsyms When combined with the -F option, this reports any symbols which a module needs which are not supplied by other modules or the kernel. Normally, any symbols not provided by modules are assumed to be provided by the kernel (which should be true in a perfect world), but this assumption can break especially when additionally updated third party drivers are not correctly installed or were built incorrectly. -E, --symvers When combined with the -e option, this reports any symbol versions supplied by modules that do not match with the symbol versions provided by the kernel in its Module.symvers. This option is mutually incompatible with -F. -F, --filesyms System.map Supplied with the System.map produced when the kernel was built, this allows the -e option to report unresolved symbols. This option is mutually incompatible with -E. -h, --help Print the help message and exit. -n, --dry-run This sends the resulting modules.dep and the various map files to standard output rather than writing them into the module directory. -P Some architectures prefix symbols with an extraneous character. This specifies a prefix character (for example '_') to ignore. -v, --verbose In verbose mode, depmod will print (to stdout) all the symbols each module depends on and the module's file name which provides that symbol. -V, --version Show version of program and exit. See below for caveats when run on older kernels. -w Warn on duplicate dependencies, aliases, symbol versions, etc. COPYRIGHT
This manual page originally Copyright 2002, Rusty Russell, IBM Corporation. Portions Copyright Jon Masters, and others. SEE ALSO
depmod.d(5), modprobe(8), modules.dep(5) AUTHORS
Jon Masters <jcm@jonmasters.org> Developer Robby Workman <rworkman@slackware.com> Developer Lucas De Marchi <lucas.demarchi@profusion.mobi> Developer kmod 07/02/2013 DEPMOD(8)
All times are GMT -4. The time now is 06:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy