Hey guys, quick question. I have a movie table which records information about certain movies. See below for the table structure.
id Title Length
-------------------------------------------
1 American Pie 160
2 Van Wilder 115
3 Not Another Teen Movie 115
4, Road Trip 130
5 Shawshank Redemption 130
6 Scarey Movie 3 150
How can I get the title of the films that are the same length as another
film? Eg, a query which displays Van Widler and Shawshank Redemption.
I've tried using GROUP BY-HAVING's and such. I just can't seem to work it out.
Any help would be greately appreciated!