Greetings SQL Team, I have a table that builds records as a status. I have a web page where I only want to grab the latest Status to the others that are old.
Fields are these
Status ... which has RECEIVED, On Hold and Sold Book Name ... name of book Seller ... Person who bought book
Can anyone provide me a select statement or an additional field and select statement that grabs the latest data as it has been populated by another procedure?
I appreciate your help.
asked Apr 16 '10 at 03:31 PM in Default
select * from
answered Apr 19 '10 at 10:26 AM
select * from table name order by status asc/desc
answered Apr 19 '10 at 10:27 AM