greater than, equal to condition

We are using DB2 v8.1.3 on Win2k.

The following query is obtaining all the rows that meet the criteria.

select col1, max(col2) from
<table_name>
where (month(current_timestamp - last_upd) = 6)
group by collab_id, track_id

Now the issue is; we need to extract all rows that are >= 6 months old..

Could you please tell me why the second query is not fetching any rows?

select col1, max(col2) from
<table_name>
where (month(current_timestamp - last_upd) = 6) OR (month(current_timestamp - last_upd) > 6)
group by collab_id, track_id

Any help is greatly appreciated.

Oracle Index for not equal condition

I would like to know how can we force oracle to use index for conditions other than = conditions.As in one of my query ,SELECT Char_nameFROM upload_controlwhere job='AAA'and num<'and cycle=1order by Char_name descIs it possible by using optimizer hint ...and whether it will really improve the per ...

Oracle UTF8 Greater Than Equal Sign

I need to put a single greater than equal sign into a database table. It is unicode 2265, a greater than equal sign. I am unable to do so with sql_plus and sql navigator The database character set is: AL32UTF8. Can someone please help me? ...

Not greater of equal to?

I have a line of code which basically reads like so:If the current date is inbetween a start and end date (using greater than and equal to) and live =2if(time() >= strtotime(''.$row->starts.'') && time() <= strtotime(''.$row->ends.'') && ($row->live == 2))But how would ...

Two not equal comparisons in an OR condition

Could anyone tell me (or link me to some place that can) why the following if-statement will execute?if (5!=6 || 7!=8) {alert("Why does this work?");} ...

greater than condition help

I am trying to create a if condition based of the amount of elements found, but IE is having a problem with it.Here is what I am trying to do.function numberCondition(){var checkSubNum = document.getElementsByTagName('li');alert(checkSubNum.length);//A TEST TO MAKE SURE I AM RETURNING THE PROPER LEN ...

Setting an xsl variable to be equal to a node attribute value based on a condition

Is there anyway to set a xsl:variable to be equal to a node attribute value based on a condition? So for example in the XML below I would want to set a variable to be equal to the value of the name attribute for the third element. So I want to pass the condition of set variable = value of name for t ...

greater than or equal too error

I need some help for a seemingly simple problem.For some reason (probably stupidity but hey) i can't get <= to evaluate correctly.my code caluclates a percent difference which calculates fine.however if the percent difference is equal to -10 the score should be 50 points, instead I keep getting 2 ...

How the condition using NOT EQUAL operator is passed as parameter to procedure

HiI m passing parameter like 'sub_bu<>bu' to the procedure named get_data.get_data procedure which used to get data from particular table. Also i m created index for the table. The problem here i suppose <>(Not equal) operator which reduce the performance of execution.My question here is ...

Date greater than or equal to...

I am having a problem getting the follow snippet of code to work correctly. I want it to show the text “Not updated.” if all six dates are not greater than or equal to the last run time.At the moment it will display the text even if just two dates are less than the last run time.//Date time format ...

Selecting where join condition not equal true

I'm trying to write some SQL that queries a mySQL database against two relational tables.Consider two classic database tables: tblProducts and tblOrderLinesI would like to query the database for all products in the tblProducts table that are NOT on a particular order in the tblOrderLines table in a ...

.NET Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

When I try to retrieve data to fill my gridview the message (Index (zero based) must be greater than or equal to zero and less than the size of the argument list.) appear... The problem seems to be a parameter, Session("onca"), I must use build the query... Code: <title>Untitled Page ...

Greater than or equal to comparison

I'm fairly new to php and mysql and I'm trying to search a column in my mysql database that contains prices, with commas and decimal places, but is of type varchar. Is there a way to compare the data in this colum with a greater than or equals comparison? The way I have tried this is like this:SELEC ...

Ubuntu Finding a good MP4 player, equal to, or greater than 8 GB

I want to buy a couple of MP4 players for my kids, whilst travelling in the car. IPods abound, but I'd rather not use one, so can anyone recommend a 8GB, or greater, MP4 player please, and your reasons for recommending it? Many ...

Oracle Accepting NULLs in an equal JOIN condition

HiI would appreciate some expert help on this issue:In order to overcome the limitations in Discoverer to create joins with OR, I need a SQL solution on how to make a equal join to accept both an exact value as well as NULL in one single conditionExample:select sum.*from sum, -- the detail tabledate ...

Oracle "Greater than or equal to" searches on numeric keys

How can I implement a "greater than or equal to" search on numeric keys?I've created a Btree which allows duplicate keys like this (I'm using Python and [pybsddb|http://www.jcea.es/programacion/pybsddb.htm] ):db_object = db.DB(dbe)db_object.set_flags(db.DB_DUP | db.DB_DUPSORT)db_object.open(define_p ...

Oracle Greater than is giving me equal to's

So I'm writing a procedure in PL/SQL that has the logic below: SELECT ... FROM ... WHERE CASE WHEN travel_time IS NULL THEN NULL WHEN travel_time = 0 THEN NULL ELSE miles/(travel_time/60) END > CASE WHEN (SUBSTR(id, 2, 3) BETWEEN '099' AND '200') THEN 60 ELSE 45 END; In the result set, I'm gettin ...

Oracle Greater than, Less than, Equal to Criteria

I've got a request for a report that includes the ability to select whether column A is greater than, less than or equal to an user-entered value and I'm stumped on how to implement this in APEX. I thought a radio button set and a text box input would work, but I'm not sure if that's the best soluti ...

Oracle Issue with not equal to empty condition

I'm new to oracle. I have a IF condition that checks if the variable is not equal to empty. But the condition fails even if the variable has its value. I have added the part of the code below.v_MyTestVar := 'Success!' ;   IF v_MyTestVar '' THEN DBMS_OUTPUT.PUT_LINE('v_MyTestVar IS NOT EQUAL TO ...

Oracle not equal to condition

which one of the following is better for not equal to condition1. A!=B2. A B ...

Date field greater than or equal to today

HelloI've been trying to solve this problem by reading a forum post at http://www.phpfreaks.com/forums/index.php?topic=234552.0 but I seem to come across an error not mentioned:Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/discos/public_html/booking/index ...

jQuery Equal Height DT/DDs

Playing around with jQuery and thought I'd try to put together a 'table looking' definition list.  I managed to get something to work in FF but IE6 doesn't seem to care what I think it should do. // equal height dt/dds$("dt").each(function () {    ddheig ...

Does the jQuery selector support an OR condition?

Hi,I'm new to jQuery and I'm looking for a selector expression to do an ORsearch.Couldn't find anything about that in the documentation and the mailing list(quite hard to search for OR...)I want to combine the following to statements into one, is that possible?jQuery("td.L a"). ...

jQuery Problem with a possible race condition

folks,I'm having a problem that I hope someone out here can help me solve. I'm using thickbox to popup a dialog that asks a user for one piece of information in a text box. I want to set focus to that text box once the dialog is on screen, but I seem to be running into a race condition (*I t ...

jQuery IS condition true like an if statement?

I'm trying to create a link that when clicked will produce an alert ifthere are any visible divs (all .detail divs are hidden by default).I have the following function but it doesn't seem I'm doing itcorrectly; nothing happens regardless of the visibility status of thedivs.$("a.save ...

jQuery Edge case Race Condition in IE with jQ 1.1.4

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head></head><body bgcolor="#ffffff" text="#000000">Hi all,Sorry for polluting the dev list, but this is something happening in apretty weird instance, and you guys would know better than anyone onany ...

jQuery Corners and equal height columns

So I am using the jquery rounded corners plugin and it breaks my equalheight columns cause it needs overflow visible. However, if I just trysetting the column heights equal it breaks wymeditor because it endsup resizing it and makes it giant. Any ideas? ...

jQuery how can a text field be hidden based on condition

Hello,I'm a little new to jQuery.Is it possible to hide/disable a text field based on a certain valuein a drop down box on the same page??I'd appreciate if someone could either show me a similar example orguide a little. ...

jQuery css : check a condition on element X and apply style on element Y. HOW?

[ jQuery/js newby ]This must be the result:------------------------When the page loads, all div's with class 'foo' that have an h4element that contains 'bar' must show up in red (the div, not h4). Thediv's that are not containing <h4>bar</h4> stay 'default ...

jQuery Adding an if(condition) traversal mechanism...

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head></head><body bgcolor="#ffffff" text="#000000"><font face="Arial">I've been playing with this...$.fn.if = function(flag) {    return (flag) ? this.pushStack( this ) : this.pus ...