Jump to content

Select on unique fields


Jaguar

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.