List:General Discussion« Previous MessageNext Message »
From:Douglas Brantz Date:August 27 2000 7:12pm
Subject:Select last record entered?
View as plain text  
Hello,

Simple question:  I have a database and I want to select a few fields
from the last record entered.
would I use select fieldname1,fieldname2 from table where id="count(*)"?
  guess I need a variable for this?

do I need a count(*) from tablename first to get the total of entries
and then define a variable for the count(*)?

Thought there might be a shortcut way to select the last record in a
table?

Thanks,

Douglas

--

Douglas Brantz
Computer Consultant
Fine & Applied Arts
Appalachian State University
Boone, NC 28608

828-262-6312 FAX
828-262-6549 OFFICE
brantzdr@stripped


Thread
Select last record entered?Douglas Brantz27 Aug
  • Re: Select last record entered?Benjamin Pflugmann27 Aug