SQL help
william humphrey
bill at bluewatermaritime.com
Wed Jan 1 13:13:28 CST 2014
Happy new year.
Can someone help me with this.
How do I request a field data from a RecID one less than the current
RecID that I know the record ID for?
I do this:
SELECT voyageID, RecID FROM voyages WHERE voyageID = 'S1301'
that gives me a RecID of 630
the result I want is:
SELECT voyageID FROM voyages WHERE RecID = 629
which gives me the voyageID for the preceding record.
Can someone help me write that in one line of SQL? Some kind of RecID
- 1 where voyageID = 'S1301' ???
Thanks
More information about the Valentina
mailing list