|
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. edb2010
(comments are locked)
|
|
select * from table name order by status asc/desc
(comments are locked)
|
|
select * from order by status asc/desc
(comments are locked)
|
Your answer
How do you define latest status? Does one of the fields hold a date? Please edit your question to provide this information.