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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/1240-query-efficiency/#findComment-4136 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.