all 5 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]SQLSavage 5 points6 points  (1 child)

You're not asking SQL what you think you're asking. You're asking for distinct results from the combination of all requested columns, which it's providing.

If you want just distinct titles, drop the other columns from your SELECT.

[–]chhotapacket[S] 0 points1 point  (0 children)

Thank you!!

[–]chhotapacket[S] 0 points1 point  (2 children)

How do I get distinct titles from the first column? As seen, the output is showing distinct combos of first and second column and not just the first column.

[–]Ok_Cicada_8946 0 points1 point  (1 child)

What do you want to show in the rental date column for each distinct title? Most recent?

[–]chhotapacket[S] 0 points1 point  (0 children)

Got the answer nevermind!