Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: sikander17
- Order by date
-
Mysql SELECT
nevermind SELECT ost.id, ost.orderId, ost.newStatus FROM order_status_tracking AS ost INNER JOIN order_status_tracking AS ost2 ON ost.orderId = ost2.orderId WHERE ost.date >= '2004-12-29' AND ost.date <= '2004-12-29' GROUP BY ost.id, ost.orderId, ost.newStatus HAVING ost.id = MAX(ost2.id)- sikander17
- Post #2
- Forum: MySQL
-
Mysql SELECT
Hello all, I have a little problem that i seem to be at a loss at solving efficiently. Here's the situation table : order_status_tracking cols : id (int), orderId (int), newStatus(int), date(date), time(time) each time an order gets a new status there is a row inserted in this table. now i...- sikander17
- Thread
- Replies: 1
- Forum: MySQL
