how to select distinct values from a database

Question

0.00/5 (No votes)

See more:

ASP.NET

query of how to select distinct values from a database.

Posted 6-Apr-14 21:15pm

Member 10578683

Add a Solution

4 solutions

Solution 1

Use distinct keyword. Give more details if you want explicit example or code.

Posted 6-Apr-14 21:16pm

ArunRajendra

Comments

Member 10578683 7-Apr-14 3:21am

string qry = "select distinct * from Products";
DataSet ds = du.GetDataSet(qry);
gdvProducts.DataSource = ds;
gdvProducts.DataBind();

Member 10578683 7-Apr-14 3:21am

here distinct keyword is not working

ArunRajendra 7-Apr-14 3:24am

If distinct work on combination of fields. Since you have given * it take all the fields from products table and build distinct. If you want distinct of specific field or fields then mention the field names.

ArunRajendra 7-Apr-14 3:24am

If you could give your requirement and data modal. We can try to build the query.

Member 10578683 7-Apr-14 4:04am

I have an gridview with two columns ID Product. and a Products database. These are the data of database. I want to populate only distinct product value in gridview.
2 Mouse
3 SMPS
4 Motherboard
5 RAM
6 HDD
7 Processor
8 Monitor (TFT)
9 Mouse Pad
11 Laptop Screen
12 Monitor (CRT)
14 joystick
15 Baterry
21 RAM
22 RAM
NULL NULL

ArunRajendra 7-Apr-14 4:15am

If you want only product name then mention select distinct name from products. If you include ID in query then it will give you duplicates.

Member 10578683 7-Apr-14 5:23am

DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'. error is coming. if i select only product

Ajith K Gatty 7-Apr-14 4:12am

I think Member 10578683 is getting output.since the query is involved with 2 fields it is not giving distinct values. values are getting repeated.

Member 10578683 7-Apr-14 3:27am

I have two fields ID and Product. I wrote the code Select distinct ID, Product from Products but still it is not working

Member 10378142 7-Apr-14 5:09am

use group by clause

Solution 2

Refer: sql_distinct[^]

Posted 6-Apr-14 21:29pm

Peter Leow

Comments

Member 10578683 7-Apr-14 3:44am

As in my gridview i have used both ID and Product. How will i use distinct keyword to get distinct product

Member 10378142 7-Apr-14 5:10am

use
select * from table_name group by ID,product

then you will get a distinct values

Solution 3

Refer

http://www.w3resource.com/sql/select-statement/queries-with-distinct-multiple-columns.php[^]

Posted 6-Apr-14 22:43pm

vsrikanth87

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aravindba · Accepted Answer · 2014-04-06T22:46:00

Solution 4

Hi
Try this

SQL

Select Distinct Product from Products ORDER BY Product

Regards
Aravind

Posted 6-Apr-14 22:46pm

Aravindba

Updated 6-Apr-14 22:50pm

v4

Comments

Member 10578683 7-Apr-14 5:22am

I did like this but an error is coming
DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'.

Member 10578683 7-Apr-14 5:37am

now it is working.Thanks all for helping me