chreez Posted October 28, 2003 Share Posted October 28, 2003 Sample Table | id | date | time | ref | 0 | 10/10/10 | 9:51 | 2 | 1 | 10/10/10 | 9:52 | 2 | 2 | 10/10/10 | 9:53 | 4 | 3 | 10/10/11 | 9:54 | 3 | 4 | 10/10/11 | 9:55 | 4 | 5 | 10/10/11 | 9:56 | 2 I need to get each row where ref != id and then get the row where date, time is greatest. Example output | id | date | time | ref | 2 | 10/10/10 | 9:53 | 4 | 5 | 10/10/11 | 9:56 | 2 The results have ref != id and other rows where ref != id are eliminated because they have lesser values in date, time. What is the best way to do this Link to comment https://forums.phpfreaks.com/topic/1240-query-efficiency/ Share on other sites More sharing options...
DylanBlitz Posted October 28, 2003 Share Posted October 28, 2003 shouldn\'t double post hehe http://www.phpfreaks.com/forums/topic9870.php Link to comment https://forums.phpfreaks.com/topic/1240-query-efficiency/#findComment-4136 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.