473,387 Members | 1,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Consolidate repetitive data into just one name each

10 Byte
Hello I have a table that lists its component name and its value several times each but with different values each time then goes onto the next component and so on. I want to create a query that will just display the components name once and not each time its used in the table. Below is the sql...
Expand|Select|Wrap|Line Numbers
  1. SELECT tbl_ComponentVar.ComponentName
  2. FROM tbl_ComponentVar
  3. ORDER BY tbl_ComponentVar.ComponentName;
CutOffBlades
CutOffBlades
CutOffBlades
CutOffBlades
CutOffBlades
FeedWheel
FeedWheel
FeedWheel
FeedWheel
FeedWheel
Bearing1
Bearing1
Bearing1
Bearing1
Bearing1
Aug 6 '19 #1
4 1398
DJRhino1175
221 128KB
Have you tried doing a group by?
Aug 6 '19 #2
soggycashew
10 Byte
I figured it out, I used Distinct at the beginning of the query...

CutOffBlades
Bearing1
FeedWheel
Aug 6 '19 #3
twinnyfo
3,653 Expert Mod 2GB
@DJ,

Hey buddy! You're starting to give advice now! Good to see you thinking about solutions for others, too!

Great to have you on the forum!
Aug 6 '19 #4
NeoPa
32,556 Expert Mod 16PB
Either approach can work. They're different and each has its pros & cons.

A quick check in the help system would have given both answers (Finding Jet SQL Help may be worth using in future as a first step. Obviously it works in the same way for ACE which replaced Jet when 2007 came out with the new ACCDB format).
Aug 22 '19 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: John | last post by:
Hi When using Table Adapter Configuration Wizard if 'Use SQL Statements' is selected as Command Type, the data table's name in dataset is retained and only its data adapter's select statements...
4
by: smcdanie | last post by:
When trying to view an asp page on my Windows 03 server, I get the following error message: Microsoft OLE DB Provider for ODBC Drivers error '80004005' Data source name not found and no...
0
by: Luca | last post by:
Hello to all, I have a problem during connection to mysql through oledb provider. I use Microsoft Visual C++ with MFC on Windows and I try to connect to mysql with the following call: hResult =...
12
by: bhanu08 | last post by:
I am get this error java.sql.SQLException: Data source name not found and no default driver specified my code for connection is { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");...
1
by: Gourisankar | last post by:
Hi, I am using a VB6 application. While I am trying to access Sybase Database stored procedure through DSR, It is giving the error "Data source name not found or Default driver is not specified" ....
5
by: Darshini | last post by:
Hi When ever opening my asp pages im getting this error..plz give some solution Data source name not found and no default driver specified
1
by: harsha1302 | last post by:
Hi all i am trying to connect my application written in jsp to the database and i am receiving this exception java.sql.SQLException: Data source name not found and no default driver specified...
4
by: santhanalakshmi | last post by:
Hi, In ODBC, i given data source name and the test connection is also successful. But i don't know, why i am facing this error DBI connect('wwwdsn','webid',...) failed: Data...
1
by: vinothvit | last post by:
error:java.sql.SQLException: Data source name not found and no default driver specified above error is shown, i have used oracle10g as database my code:...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.