Skip to main content
gamedev.net
🔒 Locked

SQL query question

Started by cpp_boy Apr 3, 2006 at 5:05 AM 1 replies 800+ views
Original Post
cpp_boy
cpp_boy
Hello. I have table with 2 columns, non of them is a key. I need query that will NOT select duplicated rows, only one occurrence of each row kind will appear after this select. Thanks in advance.
Jockel
Jockel
Use the 'distinct' clause, eg. select distinct * from table

Topic Locked

This topic has been locked by a moderator. New replies are not allowed.

Sign in to reply to this topic.