How do I query distinct values

Question

1.00/5 (3 votes)

See more:

How do I query that I get a distinct clubName based on my query? Below is the website to demo the sql query.

http://www.sqlfiddle.com/#!2/54be8b/6[^]

Posted 16-Oct-14 20:18pm

Navi.jsp

Add a Solution

Comments

OriginalGriff 17-Oct-14 2:28am

Why would I want to go to a random website to try and work out what you are trying to do?
Edit your question, dump the link and explain your tables and exactly what you are trying to do - otherwise it just looks like your homework and you are too lazy to even work it out for us. And we don't do your homework.
So explain what you need, what you have tried, and where you are stuck - or you will probably get nothing much helpful!
Help us to help you!

Use the "Improve question" widget to edit your question and provide better information.

Maciej Los 17-Oct-14 2:35am

There are distinct values! Each club name corresponds to person name.
Not sure what you mean by saying disticnt in this context...

2 solutions

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)

aarif moh shaikh · Answer 1 · 2014-10-16T20:34:00

Your table have not any duplicate records ..

that have only Clubname & ID are same but Last Name & First Name are Different .. So your query will retrieve all values ..

if you want to retrieve group distinct use this query ..

SQL

select clubname,id,lastname,firstname from persons group by clubname

Thanks
AARIF SHAIKH

/\jmot · Answer 2 · 2014-10-22T12:01:00

Solution 2

Using the

SQL

Distinct

keyword in

SQL

Sql

by the way, your fiddle link not showing anything.

Posted 22-Oct-14 12:01pm

/\jmot