Recent IT Questions

1 - 2 of 2
<<PREVIOUS 1 NEXT>>

iSeries DB2 SQL subquery to compare yesterday sales to 120 day ternd

Hi,I have an SQL query that I would like to populate with veriable date information each time it runs. If I hard code the dates, I get the results I expect. However, I can not get the date parameters to work with my query. Here's the " Hard coded version (Works)SELECT...

View Answer   |  May 30 2008   2:31 PM GMT   |  asked by MarcGreen
DB2/400, SQL Query, SQL Subselect


How to use subselect in a case statement

Getting error... "Token EXISTS was not valid...." on case statement...,case when g.GFGSTS = '2' and not exists (select a.GFTSEQ from GFTP010 a where a.GFCSQ# = g.GFCSQ# and a.GFGSTS = '3' ) then count(*) end as Void#

View Answer   |  Jan 17 2008   3:11 PM GMT   |  asked by Qpgmr
SQL, SQL Subselect, CASE statement


1 - 2 of 2
<<PREVIOUS 1 NEXT>>