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 bike"<br> "333-3" "Red bike"<br><br>Well, you get the general idea!<br><br>Thanks!
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 IamaSherpa 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
- Thread starter mawe
- Start date
- Thread starter
- #3
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, 1<br>"222-2", "Red bike", 1, 1, 1<br>"333-3", "Red bike", 1, 1, 1<br><br>is valid, but<br><br>"111-1", "Red bike", 1, 1, 1<br>"111-1", "Red bike", 0, 0, 0<br><br>is not! <br><br>How can I change the SQL statement do make this possible?<br><br>Thanks!<br><br>
SELECT DISTINCT OrderCode, ProductName, para1, para2, para3 FROM table;<br>will give you a listing. However, if all you want to do is make sure that all of the OrderCode values are unique, you could try:<br><br>SELECT count(distinct OrderCode)/count(OrderCode) FROM table;<br><br>Any result less than 1 indicates non-unique values.
- Status