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 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 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.