Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Selecting unique elements
Sorry, my mistake! The SQL is something like this:<br><br>SELECT OrderCode, ProductName, para1, para2, para3 FROM table<br><br>Now, I want to make sure that every OrderCode is unique but the ProductName and the paras can be the same. E.g.<br><br>"111-1", "Red bike", 1, 1... -
Selecting unique elements
How can I alter the following SQL statement in order to get distinct OrderCodes but not distinct ProductNames:<br><br>SELECT OrderCode, ProductName FROM table<br><br>E.g "111-1" "Red bike"<br> "222-2" "Red...
