Using DISTINCT in a SQL query

How can I use DISTINCT in an SQL query in VBA? Please provide an example. Thanks!

Requires Free Membership to View

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

I'm not sure what the limitation here that you're asking about is. DISTINCT simply limits the returned rows to avoid having duplicate entries. If you are sending a query to SQL Server from VBA, you can specify the DISTINCT modifier in a query the same way you would in a SQL query tool ie: SELECT DISTINCT SomeColumns FROM SomeTable

Join the conversationComment

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Business Analytics
- Wixom: BI applications need visual appeal
  
  Business intelligence teams should upgrade their visual design skills to create winning applications for BI users, says IT professor Barbara Wixom.
- Business intelligence program needs long-term tending to fully blossom
  
  The evolution of Quicken Loans' business intelligence strategy from static reporting to self-service BI holds useful lessons for other organizations.
- O'Reilly Strata conference tackles big topics in data science, Hadoop
  
  The O'Reilly Strata conference was the place to be to learn about the role of the data scientist and big data technologies.
Data Center
- Is energy-efficient software the next step to reduce operating costs?
  
  When the limits of hardware innovation have been reached, energy-efficient software could be way to cut electricity costs.
- Q&A;: Markley looks to lighten load as an IaaS provider
  
  Interest in cloud continues to gain traction, so how does a small infrastructure services provider compete with the Amazon Web Services of the world?
- Big data analytics software for intelligence community goes commercial
  
  IT shops that need to analyze huge volumes of data can look to a newly available big data analytics tool that was previously reserved for the intelligence community.
Data Management
- Wikibon analyst scopes big data market, predicts explosive growth
  
  Big data technologies challenge the status quo. In this Q&A;, analyst Jeff Kelly sorts through the issues and sees big-time growth in new methods.
- Gartner Magic Quadrant finds rising demand for data warehouse services
  
  A look at the latest Gartner Magic Quadrant for Data Warehouse Database Management Systems and more data management news from around the Web.
- Business capability model helps data pros sell MDM, Gartner says
  
  Data management pros need business buy-in to get funding for MDM initiatives. Modeling business capabilities can help, according to a Gartner analyst.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- Oracle Sun hardware is not for hobbyists, by a long shot
  
  Old Sun enthusiasts lament the way it used to be, and the way it will never be again. Oracle Sun hardware is a whole other animal.
- Why Ray Wang is excited about Collaborate 2013
  
  Find out what analyst R 'Ray' Wang of Constellation Research is most excited about regarding the upcoming 2013 Oracle Collaborate conference.
- What's out there for Oracle third-party tools
  
  Oracle products come with an array of integrated tools, but an ecosystem of third-party tools exists that can make an Oracle developer's life even easier.
Content Management
- Chief content officer can create value from content management noise
  
  The Google Reader RSS controversy could give chief content officers an opportunity to see what matters in content management and what doesn't.
- Rich media flood pushes digital asset management strategy to forefront
  
  Without an effective plan for managing digital assets, the increasing digital content collected by organizations could end up being a real headache.
- Avoid the pitfalls of cloud collaboration management
  
  Analyst Tim Walters explains how to build a strong case for cloud collaboration management and how to avoid problems that pop up along the way.
Windows Server
- Five things you might not know about the Hyper-V virtual switch
  
  One of the most significant improvements in Windows Server 2012 might be the Hyper-V virtual switch. What makes this low-cost option such a big deal?
- A quick look at BitLocker installation requirements
  
  A basic BitLocker installation doesn't require any unusual steps, but deploying it on Windows Server 2012 comes with a few caveats.
- How to use the BitLocker recovery options in Windows Server 2012
  
  BitLocker offers two recovery methods in Windows Server 2012. Our expert defines the options and explains how to use recovery passwords and keys.

Latest Headlines

Featured

E-Books

E-Zines

Topics

Hot Topics

Advice & Tutorials

Technology Dictionary

Tips

Ask a Question

Research Library

Product Demos

Resource Centers

Blogs