To start I have a table that has ticketholders. Each ticket holder has a unique number and each ticket holder is associated to a so called household number. You can have multiple guests w/i a household.
I would like to create 3 flags (form a, for a household that has 1-4 gst) form b 5-8 gsts... (3 Replies)
Hi,
this might be a basic question...
why is that wc -c counts 1 more per line than what is there.
for example,
> cat dum1.txt
123
12
> wc -c dum1.txt
7 dum1.txt
Thanks,
Sameer. (4 Replies)
Hi,
I have a file with 2500 entries. There are many duplicates,triplicates symbols in my file in the first column and the second column has categories(high/medium/low) . I want to have count for the occurances of each category for each unique symbol
ABC high
ABC high
ABC medium
ABC ... (2 Replies)
This is very easy , but I`m struggling .. please help modify my script,
I want to count the number of h and n , from the second column group by the first. The second column is binary, can only have h and n.
a h
a h
a n
a n
a h
b h
b h
b h
b h
b h
c n
c h
c h
c h
c h (2 Replies)
In the attached file if I do a count for "aaaaaaaaaaaa" in either notepad++ or excel I get 118,456.
However, when I do either
grep -o aaaaaaaaaaaa 12A.txt | wc -w or
awk '{
for (i=1;i<=NF;i++)
if ( $i == "aaaaaaaaaaaa")
c++
}
END{
print c}' 12A.txt
I... (3 Replies)
Hi,
Recently i have write a simple script to capture CPU high usage based on prstat but i found out that it did capture correctly. I need to capture the rows that contains CPU usage more than 3%. Below line which i thought will capture CPU usage based CPU column in prstat(9th parameter) which is... (3 Replies)
Discussion started by: tharmendran
3 Replies
LEARN ABOUT CENTOS
end
END(7) PostgreSQL 9.2.7 Documentation END(7)NAME
END - commit the current transaction
SYNOPSIS
END [ WORK | TRANSACTION ]
DESCRIPTION
END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a
crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT(7).
PARAMETERS
WORK, TRANSACTION
Optional key words. They have no effect.
NOTES
Use ROLLBACK(7) to abort a transaction.
Issuing END when not inside a transaction does no harm, but it will provoke a warning message.
EXAMPLES
To commit the current transaction and make all changes permanent:
END;
COMPATIBILITY
END is a PostgreSQL extension that provides functionality equivalent to COMMIT(7), which is specified in the SQL standard.
SEE ALSO BEGIN(7), COMMIT(7), ROLLBACK(7)PostgreSQL 9.2.7 2014-02-17 END(7)