Jaguar Posted August 1, 2007 Share Posted August 1, 2007 group number title date 1 1 Hamlet 1999 1 2 Hamlet 1999 2 1 Macbeth 1994 2 2 Macbeth 1994 2 3 Othello 2003 3 1 Othello 2003 4 1 Hamlet 1999 4 2 Hamlet 1999 group number title date 1 1 Hamlet 1999 2 1 Macbeth 1994 2 3 Othello 2003 3 1 Othello 2003 4 1 Hamlet 1999 I can't figure out how to get these results using SQL. I want to show records only where title and date are unique for each group. I need to select and show the entire table. Link to comment https://forums.phpfreaks.com/topic/62868-select-on-unique-fields/ Share on other sites More sharing options...
shamilton Posted August 1, 2007 Share Posted August 1, 2007 SELECT DISTINCT Title, Date FROM TableName Link to comment https://forums.phpfreaks.com/topic/62868-select-on-unique-fields/#findComment-313396 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.