11-20-2007
Hi Figaro,
the condition "D1.x<Q" of your query will prevent all the lines to be counted, that's why you don't get what you expect.
I suppose the SQL engine you dispose of is very basic, because this query is very easy to write in a Oracle database for instance. I guess it's basic standard SQL.
So I thought in such circumstances that the CASE instructions (which is part of standard SQL) can help you. Here would be the query:
SELECT SUM(1) / SUM(CASE WHEN x<Q THEN 1 ELSE 0 END)
FROM data
Is it what you expected or didn't I understand the question properly?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
This is the cronjob
----------------------
root@a7germ:/home/paxtemp > crontab -l|grep test
57 * * * * /home/paxtemp/test_1.sh
0,5,10,15,20,25,30,35,40,45,50,55 * * * * /home/paxtemp/test.sh
root@a7germ:/home/paxtemp >
This is the contents of test.sh script... (2 Replies)
Discussion started by: kekanap
2 Replies
2. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
3. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
4. Shell Programming and Scripting
hi all,
have got a ksh script which tries to monitor memory usage of app servers. i do a ps -0 rss -p <PID> to get the memory size in KB but when i divide by 1024 to convert to MB i dont know how to round it up ??
thanks in advance. (3 Replies)
Discussion started by: cesarNZ
3 Replies
5. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
6. UNIX for Dummies Questions & Answers
Hi,
i have 12 float variables in a bash file and i want to calculate the average of them.
Can any body help? (6 Replies)
Discussion started by: limadario
6 Replies
7. UNIX for Advanced & Expert Users
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies
8. Shell Programming and Scripting
Hi All,
I have the following time stamp data in 2 columns
Date TimeStamp(also with milliseconds)
05/23/2012 08:30:11.250
05/23/2012 08:30:15.500
05/23/2012 08:31.15.500
.
.
etc
From this data I need the following output.
0.00( row1-row1 in seconds)
04.25( row2-row1 in... (5 Replies)
Discussion started by: ks_reddy
5 Replies
9. Shell Programming and Scripting
Hi all,
I have the following code in a shell script.
Code:
if
then
echo "##"
echo "##"
echo "##################################"
for fn in `find "$1" -maxdepth 1 -iname \*"$2"* -type f`
do
echo "$fn"
... (2 Replies)
Discussion started by: naveendronavall
2 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT DEBIAN
dbix::class::sqlmaker
DBIx::Class::SQLMaker(3pm) User Contributed Perl Documentation DBIx::Class::SQLMaker(3pm)
NAME
DBIx::Class::SQLMaker - An SQL::Abstract-based SQL maker class
DESCRIPTION
This module is a subclass of SQL::Abstract and includes a number of DBIC-specific workarounds, not yet suitable for inclusion into the
SQL::Abstract core. It also provides all (and more than) the functionality of SQL::Abstract::Limit, see
DBIx::Class::SQLMaker::LimitDialects for more info.
Currently the enhancements to SQL::Abstract are:
o Support for "JOIN" statements (via extended "table/from" support)
o Support of functions in "SELECT" lists
o "GROUP BY"/"HAVING" support (via extensions to the order_by parameter)
o Support of "...FOR UPDATE" type of select statement modifiers
o The "-ident" operator
o The "-value" operator
OPERATORS
-ident
Used to explicitly specify an SQL identifier. Takes a plain string as value which is then invariably treated as a column name (and is being
properly quoted if quoting has been requested). Most useful for comparison of two columns:
my %where = (
priority => { '<', 2 },
requestor => { -ident => 'submitter' }
);
which results in:
$stmt = 'WHERE "priority" < ? AND "requestor" = "submitter"';
@bind = ('2');
-value
The -value operator signals that the argument to the right is a raw bind value. It will be passed straight to DBI, without invoking any of
the SQL::Abstract condition-parsing logic. This allows you to, for example, pass an array as a column value for databases that support
array datatypes, e.g.:
my %where = (
array => { -value => [1, 2, 3] }
);
which results in:
$stmt = 'WHERE array = ?';
@bind = ([1, 2, 3]);
AUTHORS
See "CONTRIBUTORS" in DBIx::Class.
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.14.2 2011-11-29 DBIx::Class::SQLMaker(3pm)