sql

• From: puppyoo <npayenda@emergency.qld.gov.au>
• Date: Sun, 5 Aug 2007 23:29:08 -0700 (PDT)
• To: www-ql@w3.org
• Message-ID: <12011644.post@talk.nabble.com>

i need to write a basic SQL, taking user parameter (financial year) in the
form of e.g. 2006/2007 and from that I need to extract the data for last
year 2005/2006. the 2006/2007 comes from a column in the form or string
varchar2. how can I get previous years from that entry

select year from year
where year = 'year - 1'

select year from year
where year = '2006/2007 - 1'
is this correct
-- 
View this message in context: http://www.nabble.com/sql-tf4222493.html#a12011644
Sent from the w3.org - www-ql mailing list archive at Nabble.com.

Received on Monday, 6 August 2007 11:59:59 UTC