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. Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/62868-select-on-unique-fields/#findComment-313396 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.