SQL Test/query

From: Tony Walby <tony.walby_at_bridgewatersystems.com>
Date: Wed, 15 Nov 2000 14:08:10 -0500
Message-ID: <3A12DF1A.C32C6850@bridgewatersystems.com>

Ok all you great sql programmers, lets see who can get this one. If
nobody gets this I will post the answer tomorrow.

Problem: Table description junk(last_date date, Job_name varchar2(30)). Query: Need to report any jobs that have been running for more than two hours from current time. So if last date was Nov. 15
at 3:00 the system doesn't report any problems until Nov. 15 5:00.

Rating: Intermediate Received on Wed Nov 15 2000 - 13:08:10 CST