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