select uniq records from database

Question

1.00/5 (2 votes)

See more:

i have make a table in sql. name of table is user.
which contain following field and data
name city state

pooja barmer rajasthan
ritu barmer rajasthan
pooja barmer rajasthan
ritu barmer rajasthan

i want result

name city state
pooja barmer rajasthan
ritu barmer rajasthan

that iwant to display only uniq record.if two or more records are same than select only 1 records.

please give me sql query for it?????????

Posted 2-Jul-12 6:01am

Ritu khatri

Add a Solution

Comments

[no name] 2-Jul-12 12:08pm

Did you try SELECT DISTINCT?

1 solution

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)

DamithSL · Answer 1 · 2012-07-02T06:15:00

Solution 1

SQL

SELECT DISTINCT name, city, state FROM tbl

OR

SQL

SELECT name, city, state FROM tbl GROUP BY name, city, state

Posted 2-Jul-12 6:15am

DamithSL

Comments

Ritu khatri 2-Jul-12 14:04pm

if my table contain 8 or 10 fields than i write all fields name like this but it doesnot work

[no name] 2-Jul-12 14:19pm

"it doesnot work" does not tell us anything about what does not work. Do you take your car to a mechanic and tell him that "it's broke" and he knows what you mean?