Using DISTINCT in a SQL query

by
Greg Low

Development expert Greg Low explains the purpose of DISTINCT and how to send a query to SQL Server from VBA.

Step 2 of 2:

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

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

This was first published in December 2005

PRO+

Content

Find more PRO+ content and other member only offers, here.

E-Handbook

Pricing out the new Windows Azure SQL Database

Related Q&A; from Greg Low

Should developers have permissions to SQL Server production queue?

Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ...continue reading

SQL Server id permission to create and modify tables

A SQL Server application that needs user permission to create and modify tables in SQL Server 2005 may be handled best via a schema.continue reading

Schedule stored procedure and save output to network drive

Find how to save stored procedure output to the network drive via SQL Server Management Studio.continue reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Big data picture complete with data visualization projects

IT directors at companies that are actively pulling in reams of big data may feel like they have arrived. They've put the tools ...

How to evaluate and select the right BI analytics tool

Expert Rick Sherman has advice for organizations trying to settle on BI analytics tools: Figure out which features are must-haves...

Nate Silver lays out data-driven business strategy

A lack of standards and best practices can hold back businesses from becoming more data-driven, says Nate Silver, founder and ...

SearchDataCenter

TSA packs bags tight with data center consolidation initiative

The TSA is overhauling its IT infrastructure with equipment upgrades, virtualization and cloud as part of a major data center ...

Iceland's data center opportunities and challenges

Data centers in Iceland access a stable power grid and free cooling. But questions still loom about Iceland's available capital ...

How learning Linux jumpstarted my career

Choosing an alternative to Windows 98 and learning Linux -- back in the 90s -- led Jack Wallen to his current career. How did you...

SearchDataManagement

NoSQL technology still prepping for wide enterprise entry

NoSQL database technology is built for processing speed and data flexibility. But it needs a fuller feature set and more skilled ...

Alteryx software targets Amazon big data

The latest Alteryx analytics engine gets enterprises close to Amazon big data, with nods to spreadsheet aficionados and R ...

Evaluating SQL-on-Hadoop tools? Start with the use case

In a Q&A;, Clarity Solution Group CTO Tripp Smith says to base SQL-on-Hadoop software decisions on actual workloads. Some Hadoop ...

SearchAWS

AWS re:Invent 2015 to focus on cloud management, security

Capturing more attention than years past, AWS re:Invent 2015 could see a variety of new tools. Cloud users should keep an eye on ...

New tool uses S3 to reap AWS cost savings

A new company has emerged from stealth with an alternative to AWS Auto Scaling Groups for SMBs in search of EC2 cost saving ...

Docker deployment can work wonders for test and dev

While it might not be a fit in every scenario, AWS support for popular Docker containers can save application developers some ...

SearchOracle

Data sovereignty inspires Oracle action in Canada

Oracle built a new data center in Canada to address data residency and data sovereignty concerns of the country's public sector ...

SolarWinds Database Performance Analyzer gets MySQL support

The latest version of SolarWinds Database Performance Analyzer works with MySQL, giving users of both Oracle and MySQL a common ...

How to make sense of Oracle licenses for VMware environments

Oracle licenses are a tricky subject and Oracle licensing for VMware environments doubly so. Find out about the important ...

SearchContentManagement

Government deployments play up SharePoint pros and cons

SharePoint is widely used in the public sector, and those deployments often emphasize the strengths and weaknesses of the ...

Hyland OnBase manages enterprise content

Hyland OnBase helps organizations manage documents and data to streamline business operations, with specific enhancements for the...

Lexmark's Perceptive ECM tools for content management

To address content management needs for midsize to large enterprises, Lexmark's Perceptive ECM tools are grouped into four ...

SearchWindowsServer

Six must-read Windows security resources for admins

Need to brush up on your Windows security skills, but don't have time to sort through the noise? Consider these six resources as ...

Manage user identity with Windows Azure Active Directory

Azure Active Directory allows admins to manage end-user identities and comes in three versions. Which one depends on your ...

Use a PowerShell script to force logoff an RDP session

When end users remain logged in to an RDP session, it consumes valuable resources. Use this PowerShell script to force users to ...

Dig Deeper

E-Handbook

Related Q&A; from Greg Low

Have a question for an expert?

0 comments

E-Mail

Username / Password

Password

Forgot Password?

Your password has been sent to: