Show latest status from table
Hai all...
here i've got a big problem using mySQL. hopefully someone can help me to solve this problem. what am i trying to do..
table name : status
coloumn : status_id, report_id, status_name & status_date
Eg:
status_id report_id status_name status_date
1 1 Received 2008-09-11 16:53:58
2 2 Received 2008-09-11 18:44:02
3 3 Received 2008-09-12 09:22:17
4 1 Pending 2008-09-12 10:18:32
5 2 Completed 2008-09-12 10:34:08
6 3 Completed 2008-09-12 11:09:37
7 4 Received 2008-09-12 11:09:38
so i'm trying to list down all received report only
Eg:
Report ID Status Date
4 Received 2008-09-12 11:09:38
any suggestion?
Edited 1 time(s). Last edit at 10/14/2008 11:39PM by Bug Bahrain.
Subject
Views
Written By
Posted
Show latest status from table
2577
October 14, 2008 10:06PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.