Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
N months from a give yyyymmdd date?
I would simply include a query using the sysdummy1 table to get the date. Select current date - 9 months from sysibm.sysdummy1 Let DB2 or your sql deal with it....- taasarge
- Post #9
- Forum: COBOL General discussion
-
RE: Top 35
I have used this logic to get the top 10 or 35 results back. You would have to adjust your sql to fit... SELECT * FROM CONSUMER.VDATA A WHERE 10 >...- taasarge
- Post #4
- Forum: Microsoft SQL Server: Programming
-
complex query with min, and max
This is os/390 DB2 systax but here is my try... select Hs.Documentindex FROM Header Hs where Hs.Documentindex NOT IN (select Hs.Documentindex from Header h1 where H1.Imgptr NOT IN (select Imgptr from...- taasarge
- Post #3
- Forum: Microsoft SQL Server: Programming
