When you use DISTINCT in a Select statement, you are saying that you only want one row in the result set for each distinct set of values. The result set will not have any two rows that have the same values in every column.
Let's say in table SOP30300, you have the following data:
INV001 Items: ABC, DEF, GHI
INV002 Items: DEF, JKL, MNO
INV003 Items: MNO
Then you run this statement:
SELECT DISTINCT itemnmbr
FROM dbo.SOP30300
The result set should be:
ABC,DEF,GHI,JKL,MNO
Subscribe to:
Post Comments (Atom)
Digital Transformation unleashed
You're the CIO/CDO sitting in your weekly update executive meeting with the CEO, CFO, COO, and others. You start the meeting with the pr...
-
The first time that you log in to Microsoft Dynamics GP 9.0, you can select to have default information that is specific to your job display... -
Did you hear about the latest trend in databases? If not then you should read this article about NoSQL or "not only SQL". NoSQL...
-
This month Microsoft announced the availability of Dynamics GP 2013 demo which you can download here . Most of the improvements were geare...
3 comments:
using GROUP BY will produce the same result.
ex: SELECT itemnmbr
FROM dbo.SOP30300
group by itemnmbr
Mills
http://gp-dynamics.com
Nice dispatch and this enter helped me alot in my college assignement. Gratefulness you on your information.
Nice brief and this enter helped me alot in my college assignement. Gratefulness you as your information.
Post a Comment