Click here to Skip to main content

15,899,475 members

Sign in

Sign in

Email

Password

Forgot your password?

Sign in with

home
articles
quick answersQ&A
discussionsforums
featuresfeatures
communitylounge
help?

Search within:
Articles
Quick Answers
Messages

Use my saved content filters

All Questions All Unanswered FAQ

how to select without duplicate ..?

Please Sign up or sign in to vote.

0.00/5 (No votes)

See more:

how to select without duplicate .. ??

Posted 12-Feb-11 1:42am

Comments

TweakBird 12-Feb-11 7:45am

P.S: Please try in google.

shakil0304003 12-Feb-11 10:56am

Use google 1st!!! this is a very simple question!!!

2 solutions

Top Rated
Most Recent

Please Sign up or sign in to vote.

Solution 2

Accept Solution Reject Solution

This[^] post may hlp you too.

Share this answer

Posted 12-Feb-11 2:18am

Comments

Manfred Rudolf Bihy 12-Feb-11 10:19am

Nice link! 5+

Abhinav S 12-Feb-11 10:44am

Thank you.

Please Sign up or sign in to vote.

Solution 1

Accept Solution Reject Solution

Use DISTINCT keyword with the column that can have duplicate.

Read details here[^].

Good detail description with example here: SELECT DISTINCT and ORDER BY explained[^]

Share this answer

Posted 12-Feb-11 1:52am

Updated 12-Feb-11 1:53am

v2

Comments

Sandeep Mewara 12-Feb-11 8:10am

[This reply was given as you asked what if you want to count it]

Use COUNT along with it then.

Refer: http://msdn.microsoft.com/en-us/library/ms175997.aspx

Manfred Rudolf Bihy 12-Feb-11 10:19am

Agreed! +

Add a Solution

Add your solution here

Plain Text

ASM

ASP

ASP.NET

BASIC

BAT

C#

C++

COBOL

CoffeeScript

CSS

Dart

dbase

F#

FORTRAN

HTML

Java

Javascript

Kotlin

Lua

MIDL

MSIL

ObjectiveC

Pascal

PERL

PHP

PowerShell

Python

Razor

Ruby

Scala

Shell

SLN

SQL

Swift

T4

Terminal

TypeScript

VB

VBScript

XML

YAML

OKPaste as

Strip HTML

Encode HTML

Paste as-is

Code block

Quoted Text

Best guess

To display as

The content must be between 30 and 50000 characters.

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

Submit your solution

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)

Top Experts

Last 24hrs

This month

Pete O'Hanlon	40
Ravi Bhavnani	20
Richard MacCutchan	10
lauxjpn	10
M-Badger	10

Pete O'Hanlon	1,375
OriginalGriff	1,017
Richard MacCutchan	325
Dave Kreskowiak	280
Richard Deeming	275

Related Questions

Select random number without duplicate.

no duplicates in array

Listbox to listbox without duplication

I want to joing 3 tables without duplicates

Copy Custome Folders (Without duplication) To New Folder

How to insert data into table from another table without duplicates.

Select duplicate records

Avoiding Duplicates Query

Selecting duplicating records

Need to display excel data in sql database without duplication.

Advertise
Privacy
Cookies
Terms of Use
Last Updated 12 Feb 2011

Layout: fixed | fluid

Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-05-14:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900