Sponsored Content
Top Forums Programming A different kind of counting in SQL Post 302364742 by Scott on Friday 23rd of October 2009 06:12:35 PM
Old 10-23-2009
Hi figaro.

Not sure if this is the best answer you'll get, but not sure how you'd do that in a simple group by statement.

Code:
SELECT value, COUNT(*) FROM data where value != 'Y' group by value
union
SELECT value, COUNT(*)*2 FROM data where value = 'Y' group by value

V   COUNT(*)
- ----------
X          3
Y          4

 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Some kind of message command

Hello All, hope someone here can help me with this. I am a new unix system administrator on the HP-UX machine. Every night, our operators back up our file system using one tape but as of recently, our files have gotten bigger and it now requires 2 tapes for a complete backup. Since the operators... (3 Replies)
Discussion started by: sanjit
3 Replies

2. UNIX for Dummies Questions & Answers

what kind of UNIX

ok, so i want to figure out what type of UNIX i have and in this book im reading about it, it says that i can figure out what type i have by typing the command uname in the prompt. So i did this and it came up saying Darwin?? is that part of System V UNIX or BSD or do i have LINUX? if anyone can... (2 Replies)
Discussion started by: hiei
2 Replies

3. UNIX for Dummies Questions & Answers

Kind of weird question

I recently purchased a book titled Hacking: The Art of Exploitation. When I got it home I read the preface and found out that i shouldnt have bought it. It says the code examples in this book were done on an x86 based computer (I have a mac). Is there anything I can do to make my mac run similar to... (2 Replies)
Discussion started by: Cyberaxe
2 Replies

4. UNIX for Dummies Questions & Answers

how to determine which kind of unix is used

how can i determine which type of unix (solaris ,AIX,HP-UX...) is installed on the machine that i am working? (2 Replies)
Discussion started by: gfhgfnhhn
2 Replies

5. Solaris

How to check the kind of file

Hi all, I'm working on Solaris 10 and I have to install some packets in which there are files of different kind. In this situation I need to know a command of UNIX/Solaris to check the kind of file. For example how can I know if the file has ISO or ASCII or BER or HEX format? Thank you... (4 Replies)
Discussion started by: Sunb3
4 Replies

6. Infrastructure Monitoring

sed help,,kind of urgent!!

Hello All, My problem is: I want to replace a line from a file with sed. The first word in that line is always the same in every server. The second line is server model, which of course will vary from platform to platform and I need to leave that word as it is. After the second word, I need to... (3 Replies)
Discussion started by: solaix14
3 Replies

7. Cybersecurity

What kind of hacking is going on here??

Connecting to the Internet with OpenVPN, the connection fails. Rerunning openvpn works second time round but the install is hacked at that point (e.g., a rogue 'java-security' update tries to install itself on 'yum update', yum however spots this and rejects the download, other basic things start... (3 Replies)
Discussion started by: GSO
3 Replies

8. Linux

Kind of reverse engineering

Hi everyone, I'm a linux novice , in a training purpose i have to reconstruct under windows an application running under fedora 14, the application communicates with an STB device through RS232 in a first time and then through ethernet for firmware loading purpose. All what i know is how to run... (2 Replies)
Discussion started by: nidal
2 Replies
BARRIER(3PVM)							  PVM Version 3.4						     BARRIER(3PVM)

NAME
pvm_barrier - Blocks the calling process until all processes in a group have called it. SYNOPSIS
C int info = pvm_barrier( char *group, int count ) Fortran call pvmfbarrier( group, count, info ) PARAMETERS
group Character string group name. The group must exist and the calling process must be a member of the group. count Integer specifying the number of group members that must call pvm_barrier before they are all released. Though not required, count is expected to be the total number of members of the specified group. info Integer status code returned by the routine. Values less than zero indicate an error. DESCRIPTION
The routine pvm_barrier blocks the calling process until count members of the group have called pvm_barrier. The count argument is required because processes could be joining the given group after other processes have called pvm_barrier. Thus PVM doesn't know how many group members to wait for at any given instant. Although count can be set less, it is typically the total number of members of the group. So the logical function of the pvm_barrier call is to provide a group synchronization. During any given barrier call all participating group members must call barrier with the same count value. Once a given barrier has been successfully passed, pvm_barrier can be called again by the same group using the same group name. If pvm_barrier is successful, info will be 0. If some error occurs then info will be < 0. EXAMPLES
C: inum = pvm_joingroup( "worker" ); . . info = pvm_barrier( "worker", 5 ); Fortran: CALL PVMFJOINGROUP( "shakers", INUM ) COUNT = 10 CALL PVMFBARRIER( "shakers", COUNT, INFO ) ERRORS
These error conditions can be returned by pvm_barrier PvmSysErr pvmd was not started or has crashed. PvmBadParam giving a count < 1. PvmNoGroup giving a non-existent group name. PvmNotInGroup calling process is not in specified group. SEE ALSO
pvm_joingroup(3PVM) 30 August, 1993 BARRIER(3PVM)
All times are GMT -4. The time now is 01:35 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy